VBA: how to force another instance of VB to run

H

hBear

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to open multiple instances of Word 365? 5
Automate start VB in another instance of excel and continue _without_waiting for code to finish 3
Force a File to Open in a New Excel Instance 3
Run Macro in another workbook already OPENED in another instance of Excel 3
Run file from VB in Excel 6
Excel Screen refresh while VBA is running 1
Force synchronize list with VBA 0
run a single instance of excel 8

Top