Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #109555

Re: File cannot be accessed

From piatzseo <piatzseo@gmail.com>
Newsgroups microsoft.public.excel.programming
Subject Re: File cannot be accessed
Date 2016-11-07 04:08 +0000
Message-ID <piatzseo.1265bd38@excelbanter.com> (permalink)
Organization ExcelBanter.com
References <52bdc08e-9c90-4a9e-bf54-713feb87362f@googlegroups.com>

Show all headers | View raw

admin@farmenergyconsulting.co.uk;1626708 Wrote: 
> 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 &quot;cannot be
> accessed.The file may be corrupted, located on a server that is not
> working or read-only.&quot; 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 BÃ*i đăng sao nhiều link thế. đừng spam nha bạn




-- 
piatzseo

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

File cannot be accessed admin@farmenergyconsulting.co.uk - 2016-11-05 06:35 -0700
  Re: File cannot be accessed "Auric__" <not.my.real@email.address> - 2016-11-06 15:31 +0000
    Re: File cannot be accessed admin@farmenergyconsulting.co.uk - 2016-11-08 08:41 -0800
      Re: File cannot be accessed "bart.smissaert@gmail.com" <bart.smissaert@gmail.com> - 2016-11-11 03:02 -0800
        Re: File cannot be accessed admin@farmenergyconsulting.co.uk - 2016-12-19 00:11 -0800
  Re: File cannot be accessed piatzseo <piatzseo@gmail.com> - 2016-11-07 04:08 +0000
  Re: File cannot be accessed Robert Baer <robertbaer@localnet.com> - 2016-11-07 20:01 -0800
    Re: File cannot be accessed admin@farmenergyconsulting.co.uk - 2016-11-08 08:38 -0800
      Re: File cannot be accessed GS <gs@v.invalid> - 2016-11-08 12:58 -0500
        Re: File cannot be accessed admin@farmenergyconsulting.co.uk - 2016-11-08 11:01 -0800
  Re: File cannot be accessed Dogthientruong937 <Dogthientruong937@gmail.com> - 2016-11-11 17:05 +0000

csiph-web