Hello,
I have a workbook and I want to make it open in a new excel instance.
All subsequent workbooks should also be opened on new excel instances..
I am using this code in the workbook_open event
DO NOT TEST THIS CODE.
Please Login or Register to view this content.
It opens the same workbook 100+ times until the computer hungs up.
could someone help ? tapapad
Last edited by tapapad; 04-06-2008 at 07:26 AM.
The code opens a new copy of Excel
It then opens a copy of the same file that has your Workbook Open macro.
When the book is opened the new copy of Excel runs trhe WorkbookOpen macro causing the macro to open another new copy of excel.
This process continues until you run out of memory
Their is nothing wrong with you code for opening a new copy of Excel
It is either the file iot is opening or the fact it is placed in the WorkbookOpen macro
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
mudraker,
thanks for the feedback.
My ultimate goal is to open this "workbook" in a separate EXCEL instance and prevent other workbooks being opened in the same EXCEL instance as this "workbook".
I have researched this subject quite a lot but didn't come to a viable solution.
If you can assist, I would be very grateful to you.
tapapad
Hello tapapad,
This macro will open a workbook in an new instance of Excel from the workbook the macro is in. Each time you call the macro, the named workbook will be opened in another instance of Excel. Place this macro in a standard VBA module.
Adding the MacroPlease Login or Register to view this content.
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.
Calling the Macro
StartNewExcelInstance "C:\My Documents\Test.xls"
Sincerely,
Leith Ross
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks