View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alex Suardi Alex Suardi is offline
external usenet poster
 
Posts: 1
Default saving file name and location with excel macro



how can I develop a macro in excel who allows me to automatically set
the file name (eg. content cell B3 + content cell B5) and let me choose
the file location?
The best solution wuold be something like the GetSaveAsFilename method
in which the field "Name" is automatically set.

TheFile =
Application.GetSaveAsFilename("N:\AFC\MURCA\FATTUR AZIONE\FATTURE", _
"Workbook (*.xls),*.xls", , "Save As...")

Thank you for your help.
Alex

*** Sent via Developersdex http://www.developersdex.com ***