open new Excel doc based on existing doc

  • Thread starter Thread starter rdmacaulay via AccessMonster.com
  • Start date Start date
R

rdmacaulay via AccessMonster.com

I have an application that opens exisiting Excel files (and others including
Word, Journal, etc.). I don't want the original documents changed though. I
would like the users to make their changes and then save the documents under
a different name/location of their choosing. I am hoping that some one can
provide me with some insight on how to go about this. A code example would
be really helpful.
 
how about marking the file as read-only before opening it?

''make file read-only
SetAttr "c:\path\Filename.xls", vbReadOnly

'open file
Application.FollowHyperlink "c:\path\Filename.xls"

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com
 
Back
Top