View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hBear hBear is offline
external usenet poster
 
Posts: 1
Default 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/