View Single Post
  #2   Report Post  
Old November 6th 16, 04:31 PM posted to microsoft.public.excel.programming
Auric__ Auric__ is offline
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2003
Posts: 506
Default File cannot be accessed

"Rod" wrote:

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?


Post the code that's giving you trouble.

--
I'm not sure if you're serious, or trolling the troll.