#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Save as Command Line

I need to save an .xls file as .csv without opening the spreadsheet. The
sender provides a datastream file with a .xls extension. We then open and
save the spreadsheet as .csv and process some Access applications against it.
How can I have Access convert the incoming file with a DoCmd?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Save as Command Line

If you can't open the file in excel and then save as a .csv and you have to use
DoCmd (an Access VBA command, right??), then maybe asking in a forum dedicated
to Access would be better.



SoDakRah wrote:

I need to save an .xls file as .csv without opening the spreadsheet. The
sender provides a datastream file with a .xls extension. We then open and
save the spreadsheet as .csv and process some Access applications against it.
How can I have Access convert the incoming file with a DoCmd?


--

Dave Peterson
Reply
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
Command Line Export fjurek Excel Discussion (Misc queries) 6 April 23rd 07 09:08 PM
Command Button Save As Application.ExecuteExcel4Macro ("SAVE.AS?() Paul Dennis Excel Discussion (Misc queries) 5 September 18th 06 05:34 PM
How do i convert excel to csv in command line? ( not save as) F1 Excel Discussion (Misc queries) 1 June 1st 05 03:51 AM
Q: command line in OE JIM.H. Excel Discussion (Misc queries) 0 May 30th 05 10:48 PM
can i save an existing .xls file as a .csv file using command line craigkan Excel Discussion (Misc queries) 2 February 18th 05 02:01 PM


All times are GMT +1. The time now is 08:13 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"