Thread: syntax for filename:=
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default 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



Reply With QuoteReply With Quote