Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to pass variable value between macros
Never mind. My diligence and a good reference manual paid off. It's working
fine now. Barry "BCS" wrote in message .com... I have a macro in a workbook that launches a macro in another workbook. Using "application.run..." works fine but I want to pass the value of a variable from the macro in the first workbook to the second workbook. I have made the variable Public, but when the second workbook opens there is no value. I know this works when working between different macros in the same workbook. What do I have to do differently to make this work? Thanks, Barry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pass variable from one workbook to another | Excel Discussion (Misc queries) | |||
Cells.Find: Why can't I pass a variable? | Excel Discussion (Misc queries) | |||
Pass variable to NORMINSV function to get only mean value | Excel Worksheet Functions | |||
How to pass a variable into an SQL statement | Excel Discussion (Misc queries) | |||
How to (re)set a range.value to pass -0- to a "double" variable | Excel Discussion (Misc queries) |