Getting a file and Saving a File

[carl0s66]

Is it possible to open a file, format it's contents and output the
result to another file?

(I need to automate the formatting of hundreds of files in this manner,
don't want to do it manually!)

Cheers

 

[Dave O]

The answer is "yes" with conditions. Are all the files Excel? Do
they all receive the same formatting treatment? Mostly likely this
can be automated with some programming.

 

[carl0s66]

Thanks for the reply,

The files will be .txt files.

They will all be formatted the same way (the macro to do this has been
created).

I simply need a way of getting the text file in and outputting and
corresponding .xls. The filenames are contained in a static array and
the text files correspond to the filenames of the text files. So:

The array contains the first 4 values AAA, AAC, BAA, BUA. And the text
files AAA.txt, AAC.txt, BAA.txt, BUA.txt are in a directory.

 

[Dave O]

Hi, apologies for the delayed reply.

It sounds like this should be pretty straightforward. This code will
open a file so it can be read:

Open Filename.txt for Input as #1
....
....
....
Close #1


Please email me: cyclezenATyahooDOTcom so we can chat more
efficiently.

Dave O

 

[Dave Peterson]

Off topic.

You spam-guarded your email address in the body of the message, but your address
appears in header. You may want to munge it there, too.