View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LowIQ
 
Posts: n/a
Default How to save file in a macro taking new name from cell contents?

I want to Save-as a file from within a macro, taking the new name from the
worksheet's cell contents. I want to save an order form with a file name
based on the order number contained in a worksheet cell. My question is how
to get the cell contents into the Save-as dialog box when the macro calls the
Save-as function.
Thanks.