HOW 2>> Auto Close and Save CSV file

  • Thread starter Thread starter WANNABE
  • Start date Start date
W

WANNABE

Hi, all... I am trying to copy some values into a CSV file then close and
save both files. When I use ActiveWindow.save or ActiveWindow.Close on the
CSV file it prompts my if I want to save it as is, and OF COURSE I DO...
How can I accomplish this with out the prompts??? Thank you again....
 

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

Closing workbook open as CSV 3
CSV files and having numbers and strings in there... 9
Please help with my code 7
Save file without prompting in Excel Macro 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
User prompt for CSV format 5
How to export excel sheet to CSV 1
Get Standard CSV File 2

Back
Top