Sorry but I'm slight confused:

What is a 'variable'?

And the code:
_________________________
Dim strFileName as String

Sheets("DETAILS").Activate
strFileName = Range("B2").Text

ActiveWorkbook.SaveAs Filename:= {C:\Invoice\strFileName} & strFileName
&
".xls"
_________________________

I could not get to work using VB. I honestly have no idea what I am
doing here :(

Thanks
Alex


--
alex3867
------------------------------------------------------------------------
alex3867's Profile: http://www.excelforum.com/member.php...o&userid=37220
View this thread: http://www.excelforum.com/showthread...hreadid=569909