Save As Help

R

Randy

Can anyone tell me what is wrong with this? I keep getting an error...

ActiveWorkbook.SaveAs Filename = ("C:\Personal Stuff\ABBA Communications\")
+ Range("Q1").Value


Thanks in advance for your help!
 
S

Stefi

Concatenation operetor in VBA is &:
ActiveWorkbook.SaveAs Filename = _
"C:\Personal Stuff\ABBA Communications\" & Range("Q1").Value

Regards,
Stefi

„Randy†ezt írta:
 
R

Ross Culver

Try this: ActiveWorkbook.SaveAs "C:\Personal Stuff\ABBA Communications\" &
Range("Q1").Value, assuming that Q1 has a filename in it.

Ross
 
Top