Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello:
I have approximately 1300 .csv files that I need to convert to .xls files so I can extract data from a master spreadsheet. Excel apparently requires a .csv file be open to extract the data. I could open each one individually and do a save as, but that would be rather tedious. Is there a way to programmatically do this. The .csv files are in the following format: xxnzz.csv whe xx is 01-29 (notice the leading 0) n is n zz is 01-110 (notice the leading 0 on 1 digit numbers and that the highest number is 3 digits, 2 digit numbers have no leading 0 i.e. 21n99. "Pigs can't be humans, but humans can be Pigs!" Eating at the trough of life. Oink! SowBelly |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I batch convert 97-2003 .xls files to 2007 .xlsx files | Excel Discussion (Misc queries) | |||
Convert Multiple CSV Files to XLS Files (Again) | Excel Discussion (Misc queries) | |||
converter tool to convert XL 2007 files to XL 2003 files | Excel Discussion (Misc queries) | |||
Can I convert my Quatro Pro files to MS Excel files? | New Users to Excel | |||
convert 400 word files to excel files fast? | Excel Programming |