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

why does it seems so logical when you see it.

Thx to you both




-----Original Message-----
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
.