ExcelBanter - Save As Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Save As Help (https://www.excelbanter.com/excel-programming/424795-save-help.html)

Randy

Save As Help

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!
--
Randy Street
Rancho Cucamonga, CA

Stefi

Save As Help

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

Regards,
Stefi

€žRandy€ ezt Ã*rta:

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!
--
Randy Street
Rancho Cucamonga, CA

Ross Culver[_3_]

Save As Help

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

Ross

"Randy" wrote in message
...
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!
--
Randy Street
Rancho Cucamonga, CA

All times are GMT +1. The time now is 11:11 AM.