Save as problem

[dezian]

I would like some pointers relating to closing and saving an excel file please. If anyone could help, I use macros to input client details into specific cells, on exiting this file I want the file to be saved, but I want the file name to be called from a value in a seperate cell within another excel file, this is an order number relevent to each client. Any takers ?

 

[dan1967]

To Save a workbook upon closing, go to the This Workbook object in the Microsoft Excel Objects section of the VBE Project Directory and enter:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
ActiveWorkbook.SaveAs fName
End Sub

The variable "fName" will hold your new file name for the workbook.

Dan.

 

[dezian]

Please forgive me, for I do not understand the fName variable, what I need to do is take a number from a cell in another spread sheet and use it as the file name for the one that is to be saved !

 

[dan1967]

Since I don't know what you will be using as a file name, I am using fName as an example. You would replace fName with whatever value you need to use for a file name.

Dan.

 

[dezian]

Cheers !!