View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
idealist idealist is offline
external usenet poster
 
Posts: 3
Default Make an unsaved file copy in memory?

Hi AA2e72E

Thanks for reply, but if I use "ActiveWorkBook.Saved = False" and the user clicks the "Submit" button, the program will save the currently active template file

Will this not cause my template file to be overwritten with a now completed form

I want the user to have access to a COPY of the original form (that is not yet saved)...can do?