Hi,

I am trying to make a "save as" application that does not require th
user to confirm the save. This means the script generates th
directory- and filename and automatically saves the workbook there.

Is this possible?

Yours truly,

Berend Botj

--
Message posted from http://www.ExcelForum.com

Berend

Possible, yes.

Sounds easy when you say it quickly, but you have a few variables in
there.......

When would you like to trigger the "save as"?

From what variables would the folder and filename be generated?

Here is some code that can be used to save the file and a backup copy using
the original name when you close the file.

Maybe adapt to suit or post back with more info.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.DisplayAlerts = False
ActiveWorkbook.SaveCopyAs Filename:="E:\GordStuff\Backup\" & _
ActiveWorkbook.Name
ActiveWorkbook.Save
Application.DisplayAlerts = True
End Sub

Gord Dibben Excel MVP

On Fri, 2 Jul 2004 08:42:57 -0500, Berend Botje
wrote:

Hi,

I am trying to make a "save as" application that does not require the
user to confirm the save. This means the script generates the
directory- and filename and automatically saves the workbook there.

Is this possible?

Yours truly,

Berend Botje


---
Message posted from http://www.ExcelForum.com/