I'm trying to write a generic open command in vba which opens all files with a particular file extension in a particular folder.
the best i can come up with so far is:
workbooks.opentext filename:= "C:Test" & "*" & ".txt" [etc.]
the only bit which doesn't work is the "*" bit. The macro runs but, only opens the "first" file in the folder, not all of them.
Anyone got any ideas?
Cheers,
Dave
This message was edited by Puma on 2002-04-22 03:51
This message was edited by Puma on 2002-04-22 03:51
the best i can come up with so far is:
workbooks.opentext filename:= "C:Test" & "*" & ".txt" [etc.]
the only bit which doesn't work is the "*" bit. The macro runs but, only opens the "first" file in the folder, not all of them.
Anyone got any ideas?
Cheers,
Dave
This message was edited by Puma on 2002-04-22 03:51
This message was edited by Puma on 2002-04-22 03:51