Thread: "Path/File Access Error" on Sheets.Copy
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
BrianB BrianB is offline
external usenet poster
  
Posts: 1
Default "Path/File Access Error" on Sheets.Copy
I wonder if it is because of slow server response to the creation of th
.tmp file.

Try adding a delay of a second or two into the code :-
Application.Wait Now + TimeValue("00:00:02") ' =2 second

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote