View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DarrenL DarrenL is offline
external usenet poster
 
Posts: 13
Default SAVE AS/ GET SAVE AS/

I am trying to attach a macro that will save the workbook automatically as
whatever the user inputs in a particular cell. I need to be able to save it
to a particular place as well. I do not want the "save as" box to pop up.
When they hit the macro button, it should save it as (for example) cell "A1"
in that workbook in "C:\Darren\stuff\"A1". Any help would be appreciated.
Spent alot of time on this one already.