Von Pookie
MrExcel MVP
- Joined
- Feb 17, 2002
- Messages
- 13,686
Yes, I'm hoping to fiddle with that little bit of code everyone's helped me with yet again (a.k.a. I had an idea).
I'm not sure if my idea will work, but I'm looking for opinions/help with it.
The current code I have opens all necessary workbooks that I need to use when entering information from a form. When I get the form back, I enter information into excel to "close" it, and I only need to use 2 workbooks.
Could I have a message box pop up first thing asking if I want to "open" or "close", and then open only the workbooks needed for that particular function?
(One of the workbooks is selected through the open dialog box which the current macro opens).
If any part of that needs clarification, let me know and I'll try to explain it a tad better.
Thanks!
I'm not sure if my idea will work, but I'm looking for opinions/help with it.
The current code I have opens all necessary workbooks that I need to use when entering information from a form. When I get the form back, I enter information into excel to "close" it, and I only need to use 2 workbooks.
Could I have a message box pop up first thing asking if I want to "open" or "close", and then open only the workbooks needed for that particular function?
(One of the workbooks is selected through the open dialog box which the current macro opens).
If any part of that needs clarification, let me know and I'll try to explain it a tad better.
Thanks!