file connection

[Guest]

I have a code to connect one text file to Excel
worksheet, the code like this
connection :="Text; C:\My document\File1.txt"

Now I have 8 files from file1 to file8 need to be
connected to the Excel, anyone can give me some hints on
how to correct the above codes.
Thanks

Meme

 

[luke]

-----Original Message-----
I have a code to connect one text file to Excel
worksheet, the code like this
connection :="Text; C:\My document\File1.txt"

Now I have 8 files from file1 to file8 need to be
connected to the Excel, anyone can give me some hints on
how to correct the above codes.
Thanks

Meme
.

Try the following:

for i = 1 to 8
'previous object statement':="Text; C:\My document\File"
+ + ".txt"
next