View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy[_2_] Patrick Molloy[_2_] is offline
external usenet poster
 
Posts: 1,298
Default inputbox info = filename

go to the IDE (ALT+F11) add a standard code module and paste this:

Option Explicit

Sub Save_A_Copy()

Dim fn As String
fn = Application.GetSaveAsFilename()

If UCase(fn) = "FALSE" Then Exit Sub

ActiveWorkbook.SaveCopyAs fn


End Sub

step through the code using the F8 key, and you'll see pretty easily what it
does.
Read HELP on the two key methods, called GetSaveAsFilename and SaveCopyAs
since help is pretty good on these.

"Curt" wrote:

First program I have ever wrote am 68 and having fun.
trying to have user input into inputbox then use that as filename to save
acopy as want to save a copy as need to keep active sheet for more use values
remain. Is info available to understand if & end if where to put and
relationship to code. Got all formulas and update working fine. Saving is
giving me fitsss. Seems nothing I try works
Any help greatly taken Thanks
Curt