MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Opening Multiple text files


Posted by harish shelat on April 23, 2001 6:27 AM

Barrie,
with very few modification it did work
Thanks for your help
Harish


Posted by Barrie Davidson on April 23, 2001 6:44 AM

Glad I could help you out Harish.

Posted by Jim Krest on May 31, 2001 10:21 AM

Barrie,
I just found the code you posted for opening multiple text files. Thanks, it works great. I did make one modification of adding some error checking code in case someone hits the cancel button:

Application.ScreenUpdating = False
Application.DisplayAlerts = False

'Error checking in case "Cancel" button is hit
On Error Resume Next
File_count = UBound(File_Names)
While Err.Number <> 0
Err.Clear
File_count = 0
Wend
Counter = 1
Do Until Counter > File_count
Active_File_Name = File_Names(Counter)