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

Thanks,
Chuck