Creating other file types in macros

  • Thread starter Thread starter Matthew McManus
  • Start date Start date
M

Matthew McManus

I have a macro which saves .xls files in other formats (.prn, .csv
etc). When the macro runs, I get the dialogue box "Do you want to sav
the changes to abcd.prn?" The answer is always no.

Is there any way of writing this into the macro - that I don't want t
save the changes?

Thanks
Matthe
 

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

Creating macro to use on different workbooks 1
creating Pivot Tables in Macros 1
Convert csv to Excel files 1
Do Macros cause corruption of big files 2
Using a macro to change a macro 3
How to create .csv file 2
Macros don't work when file name changes 2
More on loading a CVS into an empty formatted XLS 10

Back
Top