| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| file could not be accessed - reference xlextras.xla | Excel Discussion (Misc queries) | |||
| file.xls cannot be accessed...Read only... | Excel Discussion (Misc queries) | |||
| File cannot be accessed | Excel Discussion (Misc queries) | |||
| file cannot be accessed, could be read only | Excel Discussion (Misc queries) | |||
| "file" cannot be accessed | Excel Discussion (Misc queries) | |||
Threaded Mode
