Open csv file, run code, save, quit, repeat 3000ish times.

08-27-2008, 04:12 PM

XC MTB

Newcomer

Join Date: Aug 2008

Posts: 1

Open csv file, run code, save, quit, repeat 3000ish times.

I have written some code that I would like to apply to 3000 csv spreadsheets. Do you know what code I would need to have before and after my code to open every csv file in a folder, apply my code and then save and close the file without converting them to xls files?

Any help whatsoever would be greatly appreciated.

Cheers,
Steve

08-27-2008, 04:24 PM

gpraceman

Contributor

* Expert *

Join Date: Sep 2002

Location: Highlands Ranch, CO

Posts: 556

CSV file is just a text file with commas separating the data. Just use regular File I/O.

__________________
Awana Grand Prix and Pinewood Derby racing - Where a child, an adult and a small block of wood combine for a lot of fun and memories.

08-28-2008, 02:05 AM

JacquesL

Centurion

Join Date: Aug 2008

Posts: 116

If I understand you correctly...

Look at:
http://www.w3schools.com/asp/asp_ref_folder.asp

Remove all of the "Server" related stuff since it's ASP VB Script (decent examples though).

Then, do something like...

Code:

For each oFile in f.files
   ...open and process
next

__________________
Jacques

Posting Rules

You may not post new threads

You may not post replies

You may not post attachments

You may not edit your posts

BB code is On

Smilies are On

[IMG] code is Off

HTML code is Off

Forum Rules