SaveAs cell value ?

[dezian]

Save as problems ?

Could any help with this, I need to use a cell value as the file name, and then save to a specific directory. I have the sintax to get the cell value and save, but do not know how to save to a specific place.

The code I already have is:

ActiveWorkbook.SaveAs FileName:=ActiveSheet.Range("G7").Value & ".xls"

Any one Help Please.

Cheers Andy

 

[johnwm]

This seems to work:

ActiveWorkbook.SaveAs Filename:= _
"C:\mypath\" & ActiveSheet.Range("A1").Value & ".xls"

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'