Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have some public variables defined in an Excel97 macro which I would
like to pass to a different macro. They are "strTempFileName" and "strTempFilePath". I use the following code to to start the new macro: Application.OnTime.Now, "MacroFile2.xls!Module1" Is there a way to pass the values to the new macro when I start it? BrianG *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
passing values to other sheets | New Users to Excel | |||
Passing values in Sheet to VBA | Charts and Charting in Excel | |||
Hyperklinks - passing values | Excel Programming | |||
Passing values between 2 subs ? | Excel Programming | |||
passing values from one sheet to another | Excel Programming |