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/

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/