FilePageSetupHeader in MS Project VBA project: Display image dynamically
- by Anne Schuessler
I want to display an image when printing a page from MS Page using the FilePageSetupHeader. It all works fine if I pass in the parameter for the Text property as a string as such
FilePageSetupHeader Alignment:=pjRight, Text:="&P""C:\filepath\image.gif"""
However, I'd prefer to be able to pass the filepath to the image to display as a variable. Somehow I can't get it right.
So if I try something like the following:
vImagePath = """&P""""" & prjFilePath & "\image.gif""""""
FilePageSetupHeader Alignment:=pjRight, Text:=vImagePath
it just displays the path as a string.
I'm pretty sure it boils down to something simple like escaping the quotes in the correct way, but I've been playing around with it for a while now and I can't seem to get it right.
Any idea how this works?