| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running Macros
Thankyou! That helps a lot!!!
-----Original Message----- How about: dim wkbk as workbook set wkbk = workbooks.open(filename:="c:\...\macro.xls") Application.Run "'" & wkbk.Name & "'!module1.macro1" Steve wrote: When I do open the file first using the workbooks.open command I get a run-time error 9, Subscript out of Range error when the workbooks(filename).activate command is issued. I know this probably is not as hard as it appears, but none of the resources I have available provide a clear example of what I need to do. I know my problem has to be syntax, but MS Excel help and one other resource I have at hand do not provide any real help! Frustrated! Help! Thanks! Steve -----Original Message----- hi, is the other workbook open. if not then the macro will be unavailable. if is is open then try activing the workbook before you pass the parameter to it. workbooks(workbookname.xls).activate -----Original Message----- I am relatively new to VBA in Excel and am having trouble. I am trying to call a macro in another workbook and pass a parameter to that macro. Help does not provide a reasonable explanation or Example to follow. I would appreciate any help I can get in solving this problem! TIA Steve . . -- Dave Peterson . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| running macros | Excel Discussion (Misc queries) | |||
| HELP - Running Macros in VBA | New Users to Excel | |||
| Running Macros | Setting up and Configuration of Excel | |||
| Running Win Macros on Mac | Excel Programming | |||
| HELP: Running two Macros, one before the other | Excel Programming | |||
Threaded Mode
