SaveAs another file name, then keep working

  • Thread starter Thread starter L Mehl
  • Start date Start date
L

L Mehl

Hello --

I want the user of a workbook to be able to SaveAs (enter another filename)
and then be able to continue working in the original workbook.

I can get my code to perform the save, but then the saved-as workbook is
open, and I can't figure out the code to re-open/show the original workbook.

I saw a "...SaveAs ... Backup..." method somewhere, but can not find it now.

Thanks for any help.

Larry Mehl
 
Group -- Sorry for the sloppy research.

I just found SaveCopyAs in this group, and will dig into it.

L Mehl
 
Look for .savecopyas in VBA's help.



L said:
Hello --

I want the user of a workbook to be able to SaveAs (enter another filename)
and then be able to continue working in the original workbook.

I can get my code to perform the save, but then the saved-as workbook is
open, and I can't figure out the code to re-open/show the original workbook.

I saw a "...SaveAs ... Backup..." method somewhere, but can not find it now.

Thanks for any help.

Larry Mehl
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Saveas Not Working 7
Confirm SaveAs takes place. 6
SaveAs? 4
SaveAs using VB 2
Save As 3
SaveAs *.txt - Outputting with Text quantifiers 4
Extracting Excel2007 data from structured Storage 0
All Workbook Saved except This Workbook - Part2 3

Back
Top