View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
davidakemp davidakemp is offline
external usenet poster
 
Posts: 1
Default Creating and closing CSV file

I have a macro that opens a new workbook, copies a range and pastes i
into the new workbook, and then closes the new workbook as a CS
format. Everything works fine except that a window opens that asks i
I want to save changes to the CSV file. Clicking "Yes" in this bo
causes the macro to complete and the file is saved as desired. I
there a way to keep this "Save Changes in file xxxxx.csv" box fro
opening?
Thank

--
Message posted from http://www.ExcelForum.com