|
PureBytes Links
Trading Reference Links
|
Theo:
I have a greek version of Excel 2000, so I am not sure about the translation
of the menu items. Let's try anyway!
1. To make a macro in Excel:
Select "Tools" - and the second item beneath "Macros".
Now click on the first tab (probabbly named "Toolbars") and then click on
the first button named "Create" or "New" or something like that.
Name the toolbar "My Toolbar" or whatever.
Now click on the second tab, scroll down to "Macros" and select it.
Drag the smiling face icon on your newly created toolbar to make a new
button.
Now right-click on the face on your toolbar. A drop-down menu appears. Name
this button "DeleteDateCol" or whatever.
Now click on the last item of the same drop-down menu, locate and select the
sub named "ThisWorkbook.DeleteDateColumns"
Close the windows you don't need. Leave your toolbar there or drag it where
you want.
Now try it: Drag some indicators from MS, click your button and watch the
date columns being deleted!
2. Search for a free utility called "MacroMaker". If you want a really
powerful macro utility, go to CE software
and buy "Quickeys". It worths every penny!
3. Option Compare method should be put in the General Declarations section
of Visual Basic. That's how VB or VBA
knows what method it should use to compare strings ..
I hope this helps. If your Excel menus are different than mine then you must
find a way to tell me how they look like.
I used the English version in the past, but this one is unfortunately in
Greek, so if I tell you the Greek names they will "sound Greek to you" :-)
Spyros
Date: Mon, 23 Sep 2002 16:52:50 +0200
From: "Theo Lockefeer" <sky40912@xxxxxxxxx>
Subject: Re: Auto-deleting Date columns in Excel (read this instead!)
Spyros :
Thanks !
Please look at my TL remarks.
- ----- Original Message -----
From: "SR" <raftsp@xxxxxxxxx>
To: <metastock@xxxxxxxxxxxxxxxxxx>
Sent: Monday, September 23, 2002 12:53 PM
Subject: Auto-deleting Date columns in Excel (read this instead!)
>
>
> Here is a sub-routine in VBA that deletes the columns with a "Date"
header.
> Just paste it in the VBA workbook code and click RUN.
> If you like you can create a macro that will call it from inside the Excel
> workbook, so you will not
> have to switch every time to VBA to run it.
TL : how ?
> It's also a good idea to use a macro utility to make copy-pasting multiple
> indicators between MS and Excel
> a single click's task.
TL : that would be ideal ! Do You have that macro ?
>
> Make sure that the first line "Option Compare Text" appears before any
other
> procedures.
TL : Can you explain : Why ?
Thanks again !
Theo
TL : i was up +6,62 % last week but whip-sawing put me back on earth
money management saved my ass again !
( Zig zagging as we say :) ) )
|