View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
c mateland c mateland is offline
external usenet poster
 
Posts: 52
Default How to open a workbook as a copy?

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