Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA: how to force another instance of VB to run
I'm currently using a vb as front end and excel as backend for a
timekeeping program. For the sake of time-efficiency, i do not save data into the excel file per login/time in (button click) and close the instance, since i've learned in the first implementation that this takes a few seconds depending on the specs of the localhost. The problem comes in when excel is opened by a user to view a non-related excel document, and the timekeeper excel sheet is VISIBLE because excel did not run another instance for the other document. This leaves the timekeeper document open to tampering. Is there a way i can force Excel to open another instance if a non-related excel document is clicked? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to force another instance of VB to run
Try using
Application.IgnoreRemoteRequests = True -- Regards, Tom Ogilvy hBear wrote in message ... I'm currently using a vb as front end and excel as backend for a timekeeping program. For the sake of time-efficiency, i do not save data into the excel file per login/time in (button click) and close the instance, since i've learned in the first implementation that this takes a few seconds depending on the specs of the localhost. The problem comes in when excel is opened by a user to view a non-related excel document, and the timekeeper excel sheet is VISIBLE because excel did not run another instance for the other document. This leaves the timekeeper document open to tampering. Is there a way i can force Excel to open another instance if a non-related excel document is clicked? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Force excel to start new instance when I double-click a workbook | Excel Discussion (Misc queries) | |||
How does one name, for instance, A1 as 'last name?' | New Users to Excel | |||
count instance | Excel Worksheet Functions | |||
First Instance | Excel Discussion (Misc queries) | |||
How do I get rid of a 2nd instance (xls:2)? | Excel Discussion (Misc queries) |