That was it! I couldn't remember the strategy on doing it.

Thanks a bunch!

-Chuck

On Mar 15, 12:44 pm, Tom Ogilvy
wrote:
sName = "c:\shared files\projects\mccoy.xls"
workbooks.open sName, ReadOnly:=True

--
Regards,
Tom Ogilvy



"c mateland" wrote:
Excel 2003

Sorry, I'm drawing a blank. I just want VBA to open an existing xls as
a copy. The user will then save it where it needs to go.

Example path and file:
c:\shared files\projects\mccoy.xls

Another scenario is if it's a template file:
c:\shared files\projects\mccoy.xlt