Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba/macro recognizing other worksheets open
How can I have the macro / vba prompt me for the name of the workbook
and sheet each time I run it? Both the active sheet and the one I would be pulling from will be open, but the one I am pulling from will change in name and its sheet names will be different each time. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba/macro recognizing other worksheets open
hi
use variables with the inputbox. dim wb as workbook dim ws as worksheet wb = inputbox("Enter the name of the workbook.") ws = inputbox("inter the name of the worksheet.") that's the therory. since you didn't post any code, i not exactly sure how to work it in. play with it. Regards FSt1 " wrote: How can I have the macro / vba prompt me for the name of the workbook and sheet each time I run it? Both the active sheet and the one I would be pulling from will be open, but the one I am pulling from will change in name and its sheet names will be different each time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro not recognizing .xlsx spreadsheet | Excel Discussion (Misc queries) | |||
Macro not recognizing blank lines as blank | Excel Discussion (Misc queries) | |||
macro for all open worksheets? | Excel Programming | |||
Macro to Open and Compile Multiple Worksheets that are password protected | Excel Programming | |||
Defining an auto-open macro that prints specific worksheets | Excel Programming |