| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running Macros
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Running Macros
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 . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Running Macros
I tried this and am still having trouble. I have been
opening the file with the following: Workbooks.Open fileName:="c:\dirName\filename" This works to open the file. When I try the application.run command, I get a run time error (1004): Method 'Run' of object '_Application' failed Thankyou in advance fore your help! 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 . . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Running Macros
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 . . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Running Macros
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 |
|
#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 . |
| Reply |
| 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 | |||
Hybrid Mode
