Thread: VBA code for: Saving to desktop?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Shatin Shatin is offline
external usenet poster
  
Posts: 54
Default VBA code for: Saving to desktop?
Following is based on code posted in this newsgroup not so long ago
and works well for me:

ActiveWorkbook.SaveAs _
Filename:=Environ("USERPROFILE") & "\Desktop\" & filename, _
FileFormat:=xlNormal
Reply With QuoteReply With Quote