So, essentially I have made an instant messenger with Excel, which uses a VBScript to notify the VBA code to fire a certain sub when a parameter is met. In the code Application.Visible = False, so my problem actually lies with opening any different Excel files through their respective shortcuts. I realize there are certain commands, such as Application.IgnoreRemoteRequests = True, however, this also blocks input from my VBScript... I also tried creating new Excel applications when a different file is opened inside the This Workbook, Activate and Deactivate modules, but that was similarly unsuccessful. If anyone has a creative idea for this, I would appreciate it. Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to open new instance of excel during use of UserForm
- Thread starter mnik3
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Solved