Thread: Macro to save contents of a named range to a file
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben[_2_] Gord Dibben[_2_] is offline
external usenet poster
  
Posts: 621
Default Macro to save contents of a named range to a file
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs FileName:="C:\myfolder\" & _
ActiveWorkbook.Name
Application.DisplayAlerts = True


Gord

On Sun, 1 May 2011 19:02:56 -0700 (PDT), kittronald
wrote:

Gord,

Figured it out - partly.

Had to use the Goto command to specify the name.

However, when the filename to save to already exists, how do you
specify "Yes" to the overwrite prompt in the macro ?



- Ronald K.
Reply With QuoteReply With Quote