Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Choose (open) workbook for actions on user prompt
Hello, The headline might not be very descriptive. My question is: How can i get excel to recognize or let user choose, which open workbook to process with macro, if this workbook has differing name from time to time. The macro now uses the "open" function, to open a workbook of choice and then perform actions, however i i want a different action performed(all is in user forms), i must close the workbook again. How can i give the user the option to choose an open workbook/window while in a sort of user form? I do not wish for something where the user has to select a cell in the workbook and then run macro, but rather run userform then select. Thank You! -- erikhs ------------------------------------------------------------------------ erikhs's Profile: http://www.excelforum.com/member.php...o&userid=32788 View this thread: http://www.excelforum.com/showthread...hreadid=542427 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Choose (open) workbook for actions on user prompt
Thank you! I will try this when i get the time. -- erikhs ------------------------------------------------------------------------ erikhs's Profile: http://www.excelforum.com/member.php...o&userid=32788 View this thread: http://www.excelforum.com/showthread...hreadid=542427 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i set up a user prompt at the start of an excel workbook ? | Excel Worksheet Functions | |||
Prompt user on automatic updates for Workbook Links | Excel Discussion (Misc queries) | |||
When I open a workbook, how can I choose which worksheet opens? | Excel Worksheet Functions | |||
User prompt - Open file - Perform action | Excel Programming | |||
workbook open read only without prompt | Excel Programming |