Some help for inexperinced VBA users

[Lo Lun To]

I see a great number of requests on this board for VBA code that can be obtained merely by running the macro recorder.

Before posting requests for macro code, try the macro recorder.
This may result in your question to this board being unnecessary.
In addition, your VBA knowledge is likely to be more enhanced by having found the code yourself, rather than being supplied by others.

Persons who are experienced with VBA frequently use the macro recorder to get code.
Many of the answers supplied to the many simple VBA questions on this board are most likely obtained from the macro recorder.

 

[Mark O'Brien]

Where is this "test" macro situated? In a module in the same workbook? It should work, unless "test" is declared like this:<pre>
Private Sub test()</pre>

If it is, change "Private" to "Public".

Or, if the macro isn't too long (I don't usually suggest this) just copy and paste the code into the "WorkBook_Open" event.

_________________<font color = green> Mark O'Brien
This message was edited by Mark O'Brien on 2002-05-10 08:23

 

[kkknie]

Change the line test to:

Application.Run ("KKMacros.xls!activepath")

where KKMacros.xls is the name of your personal macro workbook and activepath is the name of the macro you want to run.

As for auto scheduling, I believe you can use windows scheduling to handle this. I've not used it so cannot give much more info...

K

 

[NateO]

You can call the private procedure from an event procedure if you call it the long way:

Application.Run ("test")

 

[Mark O'Brien]

Defeats the purpose of "Private" if you ask me then. (but let's not bicker about MS's philosophy, there are better things to bicker about, like animated smilies. )

 

[NateO]

Not to be too arguementative , but, I think it depends who/what you want the procedure to be sheilded from, not your procedures, but from the macro dialog box.

The windows task scheduler works fairly well. I've used it to launch excel on LAN login, which should fire a workbook_open procedure (not an auto_open procedure). Also, you can place files or shortcuts to files in your xlstart folder to launch upon Xl's launch.

 

[jkpd2000]

I did the test macro with record macro feature. Is it ok?

 

[NateO]

Hard to say from Minneapolis. Did it work?

You can record opening the file and saving it as something else (e.g., a cell value, a certain name, etc...) But you can record the workbook_open macro that calls the recorded macro from your personal.xls file. See Mark's post earlier on where to put it and the posts above on calling it

application.run("personal.xls!MacroName")


_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue">O</font></font></font>

This message was edited by NateO on 2002-05-10 09:06