Add a prefix to a file name?

[Philip1957]

Greetings,

I have a macro that creates a new workbook and saves it with the file name composed of a number in cell A09.

ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & "\TDN Forms\" & Worksheets("Rev #").Range("AO9") & ".xlsx", CreateBackup:=False

How can I insert a prefix to the file name? Currently it saves the file as just a number, 35.xlxs, but I would like it to save the file as TDN-35.xlxs

Thanks in advance for any assistance.

~ Phil

 

[JoeMo]

You could put TDN-35 in cell AO9. If that's not acceptable try:

ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & "\TDN Forms\" & "TDN-" & Worksheets("Rev #").Range("AO9") & ".xlsx", CreateBackup:=False

 

[Philip1957]

Thank you very much!

As is usually the case, I made a newbie error and had the quote marks wrong.

~ Phil

 

[JoeMo]

Thank you very much!

As is usually the case, I made a newbie error and had the quote marks wrong.

~ Phil

You are welcome - thanks for the reply.