Using VBA to Name and Save a PDF

[jjykim]

Hi there,

I have a piece of code that converts a document into a pdf. I'm trying to save the report as "2017 Annual Report for [XYZ]"

Right now, when I run the code, it saves the file as whatever is stored in the SaveAsString, which is Person's name.

Filename:=SaveAsString & ".pdf", _

I want to add "2016 Annual Report" in front of this. How should I do that? Can I concatenate the "2017 Annual..." with the "SaveAsString" If so, how do I do that? Thanks!

 

[Trebor76]

Hi jjykim,

Since you've already defined a variable, I'd use the following:

SaveAsString = "Trebor76"
SaveAsString = "2016 Annual Report " & SaveAsString

You could just add the text like so...

Filename:="2016 Annual Report " & SaveAsString & ".pdf", _

...but in my humble opinion this defeats the purpose of having the SaveAsString variable.

Regards,

Robert

 

[jjykim]

Hi jjykim,

Since you've already defined a variable, I'd use the following:

SaveAsString = "Trebor76"
SaveAsString = "2016 Annual Report " & SaveAsString

You could just add the text like so...

Filename:="2016 Annual Report " & SaveAsString & ".pdf", _

...but in my humble opinion this defeats the purpose of having the SaveAsString variable.

Regards,

Robert

Thanks!