syntax for filename:=
 

can someone please help me with the proper syntax.

this is what i have


Dim myfile As Variant
Dim mypath As Variant
mypath = "\\Server1\Users\jhocking\My Documents\"
myfile = CStr(TextJobID.Value)

ActiveWorkbook.SaveAs Filename:="mypath & myfile & ".xls"

--
jhahe
-----------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...fo&userid=2359
View this thread: http://www.excelforum.com/showthread.php?threadid=47345

syntax for filename:=
 

ActiveWorkbook.SaveAs Filename:=mypath & myfile & ".xls"

--
Regars,
Tom Ogilvy

"jhahes" wrote in
message ...

can someone please help me with the proper syntax.

this is what i have


Dim myfile As Variant
Dim mypath As Variant
mypath = "\\Server1\Users\jhocking\My Documents\"
myfile = CStr(TextJobID.Value)

ActiveWorkbook.SaveAs Filename:="mypath & myfile & ".xls""


--
jhahes
------------------------------------------------------------------------
jhahes's Profile:
http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=473457