I have written a small excel sheet which acts like a questionaire for employees. Everyone has a copy of this file on their desktop, when they fill out the form and submit it opens a master file and adds that persons details to the list. What I want to do is add a routine which:
before submitting the users details checks if the file is already open
if it is, the results are not sent to the master list but saved as a temporary .xls sheets in the same directory
I can then add a routine to the Auto_open macro to check for temp files and add their contents next time the file is opened, then delete the temporary file from the directory.
Can this be done within a macro? or can anyone think of a better way around this problem?
Thanks-in-advance
UKPhil
before submitting the users details checks if the file is already open
if it is, the results are not sent to the master list but saved as a temporary .xls sheets in the same directory
I can then add a routine to the Auto_open macro to check for temp files and add their contents next time the file is opened, then delete the temporary file from the directory.
Can this be done within a macro? or can anyone think of a better way around this problem?
Thanks-in-advance
UKPhil