Save As Help

  • Thread starter Thread starter Randy
  • Start date Start date
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!
 
Concatenation operetor in VBA is &:
ActiveWorkbook.SaveAs Filename = _
"C:\Personal Stuff\ABBA Communications\" & Range("Q1").Value

Regards,
Stefi

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

Ross
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

save as cell A1 to to a specific drive 3
Save As File Format 1
VB Help If Statement in Selection.ShowDetail = True 5
Simplify save code 11
date format in CSV 13
Saving File 6
Save as marco 3
Run Macro If Cell have "x" value 0

Back
Top