'Save as' problem

  • Thread starter Thread starter joecrabtree
  • Start date Start date
J

joecrabtree

To all,

I have a macro that imports some data from a text file, and then
produces a graph of the data. I then save only the graph, and
associated worksheet ( i.e. the data ) as a seperate file. I use the
command 'Save as' to save the file.

When I do this it obviously closes the original file, and leaves the
user looking at the saved as file. Is there anyway I can keep my
original workbook (DATA.xls) open, while saving the file. So that the
user can then continue to use the workbook (DATA.xls) without any
interuption?

Thanks for your help in advance,

Regards

Joseph Crabtree
 
Use SaveCopyAs instead of SaveAs

ActiveWorkbook.SaveCopyAs

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 

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

Extract Certain Data from closed file 2
Plot graph depending on drop down box selection 1
Saving a Workbook using info from a Cell??? 5
Save as problem 1
Workbook_Open command fails and blows up all cell formulas 2
Save only one sheet from workbook 3
Data Selection for graph plotting 3
Closing Hidden Workbook when Active Workbook is Closed 5

Back
Top