for x = file1 to file5000 ??? next file please.
Posted by Christopher on October 03, 2001 1:33 PM
I have a macro that imports a txt file, grabs two cells of data. A Date and Time. I have it then paste it into a new spreadsheet that I'm gathering all the dates and times of each file. Right now I have it use the application.openfile object and I have to select each file everytime I want to import. How do I have it do my macro to every file in the directory? I think I would use a "for" command, but how do I tell it to go to the next file?
Any help would be great.