Thread: save as
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
downwitch downwitch is offline
external usenet poster
  
Posts: 12
Default save as
Try ActiveWorkbook.SaveAs

geebee noSPAMs wrote:
hi,

i have the following:

Dim sFileName As Sting
sFileName = Application.GetSaveAsFilename

I would like to know how to avoid displaying the file saver dialog box that
lets you choose the path. I would like to specify the path programatically.
Can anyone help with this?

thanks in advance,
geebee

Reply With QuoteReply With Quote