Saving problems in Excel

[dezian]

Anyone, I would like to use the value of a cell within my spread sheet as the file name for the saved version of my file, I.e Cell A2 value is 100200, I would like to use this number to save my excel file as 100200.xls. The value of the cell changes with different clients but will always be a numerical value! Any Takers.

Cheers Andy

 

[Stretchwickster]

Something like this would work:

  ActiveWorkbook.SaveAs Filename:=ActiveSheet.Range("A2").Value & ".xls"

Btw, you can add extra arguments to password protect etc. Check out SaveAs in the VBA help.

Clive

http://www.kucu.co.uk

Ex nihilo, nihil fit (Out of nothing, nothing comes)

 

[dezian]

Cheers, thanks for your time.

Andy