Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Export Excel tuncating leading zeros while export to excel from da | Setting up and Configuration of Excel | |||
help with EXCEL SCRIPT | Excel Discussion (Misc queries) | |||
help with EXCEL SCRIPT | Excel Discussion (Misc queries) | |||
export re-order input fields to export file [csv] | Excel Worksheet Functions | |||
Excel 2000/XP script to Excel97 script | Excel Programming |