| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
parameter to open file name in macro
I am trying to write a macro to print many worksheets from many workbook.
However, each month some of the worksheet have different naming based on the month. For example: "NOV_PJ" and the next month "DEC_PJ". is there a way to have a parameter in the macro to ask for the file name before having the macro print out the worksheet? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open Excel file from VB and open MACRO | Excel Discussion (Misc queries) | |||
| Open Access Macro, then put a value into a parameter field | Excel Programming | |||
| Open a file do a macro ( made) and open next succesive file | Excel Programming | |||
| Macro to call a file that has a auto open macro in the file itself | Excel Programming | |||
| Automate open file, update links, run macro, close and save file | Excel Programming | |||
Threaded Mode
