View Single Post
  #1   Report Post  
Old November 5th 16, 02:35 PM posted to microsoft.public.excel.programming
[email protected] admin@farmenergyconsulting.co.uk is offline
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2016
Posts: 5
Default File cannot be accessed

Hi
I have a macro that sequentially opens data files (csv data in .rnd files), copies data to the main workbook, then closes the file. This normally works well but when the number of files reaches some arbitrary number, around 200, I get the message: Filename "cannot be accessed.The file may be corrupted, located on a server that is not working or read-only."
If I process in blocks of less than 150 the same file opens without problems. It would be good though to keep all 250 files together. Any ideas of how to avoid the issue?
Thanks,
Rod