| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing File Name To Macro
Hi I have two workbooks. One that always has the same name and the 2n one that changes names constantly (I get tons of files through email) How can I pass to a macro I have the name onf the workbook that alway changes? In other words: I have the one that never changes open an then I open the 2nd one, which always has a different name. When I ru my macro, I need to be able to pass to the macro the name f the secon workbook I just open thanks in advance,   :-- halem ----------------------------------------------------------------------- halem2's Profile: http://www.excelforum.com/member.php...nfo&userid=993 View this thread: http://www.excelforum.com/showthread.php?threadid=55012 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing parms to a VBS file or a macro when executed? | Excel Programming | |||
| PASSING VARIABLE TO .xlT FILE FROM .xlA FILE (CONTAINS 'Auto_Open' PROCEDURE) | Excel Programming | |||
| passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) | |||
| Passing variables from Outlook Macro to Excel Macro | Excel Programming | |||
| passing variables from an excel macro to a powerpoint macro | Excel Programming | |||
![halem2[_65_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
