Getting a file and Saving a File
 

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.


--
carl0s66
------------------------------------------------------------------------
carl0s66's Profile: http://www.excelforum.com/member.php...o&userid=16620
View this thread: http://www.excelforum.com/showthread...hreadid=320067

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

carl0s66 wrote in message ...
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.

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.

Dave O wrote:

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

carl0s66 wrote in message ...
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 Peterson