Running Macros
From: Steve (anonymous_at_discussions.microsoft.com)
Date: 09/20/04
- Next message: sebastienm: "RE: How to turn off dragging for a Pivot Table field"
- Previous message: kls: "Do Loop doesn't process"
- In reply to: anonymous_at_discussions.microsoft.com: "Running Macros"
- Next in thread: Dave Peterson: "Re: Running Macros"
- Reply: Dave Peterson: "Re: Running Macros"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 20 Sep 2004 09:54:46 -0700
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
>>.
>>
>.
>
- Next message: sebastienm: "RE: How to turn off dragging for a Pivot Table field"
- Previous message: kls: "Do Loop doesn't process"
- In reply to: anonymous_at_discussions.microsoft.com: "Running Macros"
- Next in thread: Dave Peterson: "Re: Running Macros"
- Reply: Dave Peterson: "Re: Running Macros"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
