ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel Export Script (https://www.excelbanter.com/excel-programming/318638-excel-export-script.html)

[email protected]

Excel Export Script
 
I'd like to write a script that takes as its argument an excel workbook
file, then creates comma delimited text files of every one of its
sheets, with the sheet title as the file name. Where would I start to
accomplish this task? I want it to ma an external vbscript or perl
script not an excel macro. I am assuming I wil need an excel object
model, where can I find that as well? Thank You.


Frank Kabel

Excel Export Script
 
Hi
as a starting point:
http://www.cpearson.com/excel/imptext.htm

--
Regards
Frank Kabel
Frankfurt, Germany

schrieb im Newsbeitrag
ups.com...
I'd like to write a script that takes as its argument an excel

workbook
file, then creates comma delimited text files of every one of its
sheets, with the sheet title as the file name. Where would I start

to
accomplish this task? I want it to ma an external vbscript or perl
script not an excel macro. I am assuming I wil need an excel object
model, where can I find that as well? Thank You.




All times are GMT +1. The time now is 01:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com