LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 116
Default Automatic save as for CSV

I have a list of csv files that I need to open re-format and then close the
file and re-name so that I can import into Access. (Access doesn't recogonize
the current name with dashes). I am manually doing a "save as" now. I was
also hoping to sequentially name the files for instance, logfile1, logfile2,
logfile3, logfile4 etc... Can it be done? If I add it to the bottom of my
format macro it would all be in one step.

Thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/201004/1

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Where does Save As Automatic Backup save its files? JoAnn Excel Discussion (Misc queries) 3 April 4th 08 08:48 PM
Automatic Save As Macro wrvadmin Excel Discussion (Misc queries) 3 January 23rd 08 05:48 PM
Automatic Save As gramps Excel Discussion (Misc queries) 2 April 4th 07 04:46 PM
Automatic Save and Exit duane Excel Discussion (Misc queries) 1 July 18th 06 10:32 AM
Automatic save workbook rufusf Excel Worksheet Functions 0 March 22nd 06 07:49 AM


All times are GMT +1. The time now is 03:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"