Thread: Save as macro
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Save as macro

Type GetSaveAsFilename in the immediate window, select it, then press F1.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"JK" wrote in message
oups.com...
wrote:
And where do I find VBA help (would probably help me with many
questions:-) ? When I press the questionmark in my Visual basic window,
and search for GetSaveAsFilename in Index, I get no match (only
GetObject function and GetSetting function).


put this line to your code:

Application.GetSaveAsFilename

It will open the Save As -prompt