Notifications
Clear all
VBA & Macros
3
Posts
3
Users
0
Reactions
9
Views
Topic starter
I have a VBA macro which has to open around 20,000 Las files as text for input one at a time. An error occurs "Too Many Files" after processing 256 files. I assume I must close each Open file For Input after processing. I tried close (File Name) and Close(File Path) without any success.
Actually I need a command line to add to my loop to close each Open file For Input at the end of cycle of the loop
Posted : 31/10/2020 9:53 pm
Do you have an example of the code you are using? Please attach a workbook
Posted : 01/11/2020 2:12 am
Hi Mourad,
What are you doing with these files?
Power Query might be a better solution depending on what you are doing.
Phil
Posted : 02/11/2020 12:14 am
