SaveAsFilename

[belmoncm]

In using the SaveAs Filename function in VBA, I want to have the spreadsheet dynamically assign the filename by getting the contents of two cells in the workbook and concatenating them together. Basically, the spreadsheet with the values of cell A1 (JanesSpreadsheet) and cell B2 (May2002) would save as Filename = "JanesSpreadsheetMay2002". I can't seem to find any code examples that don't explicitly name the file. Can anyone help?

[brettvba]

On 2002-05-23 15:37, belmoncm wrote:
In using the SaveAs Filename function in VBA, I want to have the spreadsheet dynamically assign the filename by getting the contents of two cells in the workbook and concatenating them together. Basically, the spreadsheet with the values of cell A1 (JanesSpreadsheet) and cell B2 (May2002) would save as Filename = "JanesSpreadsheetMay2002". I can't seem to find any code examples that don't explicitly name the file. Can anyone help?

Hi Try

=("a1").value & ("B2")value

[Ian Mac]

On 2002-05-23 15:37, belmoncm wrote:
In using the SaveAs Filename function in VBA, I want to have the spreadsheet dynamically assign the filename by getting the contents of two cells in the workbook and concatenating them together. Basically, the spreadsheet with the values of cell A1 (JanesSpreadsheet) and cell B2 (May2002) would save as Filename = "JanesSpreadsheetMay2002". I can't seem to find any code examples that don't explicitly name the file. Can anyone help?

for a first post that's a darn GOOD explanation.

ThisWorkbook.SaveAs "C:" & Sheet1.Range("A1").Value & Sheet1.Range("B2").Value

where is only ment to be 1 backslash
_________________
Share the wealth!!
Ian Mac

[ This Message was edited by: Ian Mac on 2002-05-23 16:11 ]

[belmoncm]

Thank you for the assistance, it works!