View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
paul[_10_] paul[_10_] is offline
external usenet poster
 
Posts: 3
Default VBA filesavename

filesavename = Application.GetSaveAsFilename(Range("h9"))

dear ,

above line activated by a "click/button" event. which
reacts quit fine.

I get a window to search for the wanted folder and the
opportunity to save the file with name created in the cell
h9.

However after pressing "save" the window closses but
nothing has been saved!!

did I forgot something?


kind regards

Paul