Thread: SaveCopyAs cannot access opened file?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Kelston[_2_] Kelston[_2_] is offline
external usenet poster
  
Posts: 1
Default SaveCopyAs cannot access opened file?
This may be inelegant, but I have got round this problem by using:

Application.Sendkeys ("y")
ActiveWorkbook.SaveAs Filename:="whatever your file name is

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

Reply With QuoteReply With Quote