Excel - VBA for Open As Copy ?

[Meander365]

Excel 2000.

Im trying to open up an Excel workbook but as a copy. You can do this normally with the Options button on the File-->Open dialog box.

Can anyone provide me with the code for this ?

Thanks!

 

[RobBroekhuis]

You have to first make a copy of the file, and then open it. Or, read the original file, and do an immediate Save As with "copy of " front-appended to the name:

Workbooks.Open MyFileName
ThisWorkbook.SaveAs Thisworkbook.path & "Copy of " & thisworkbook.name

Rob

 

[Meander365]

...of course !

Thanks Rob

M