I have some excel VBA script that will print data that is entered into an excel spreadsheet to pdf and then insert it into a default layout pdf as a watermark. In order to keep this as understandable and short as possible, it appears that when using this method of inserting a watermark using VBA, that the watermark is not actually part of the pdf. When the pdf is created, it is 11x17 and in portrait mode. To fill out the data fields it must be rotated to landscape mode. The problem arises when you try to print the pdf. If you print it while it is in landscape mode, the pdf is printed in landscape but the watermark is printed in portrait. This means that all the data that is supposed to be there is rotated 90 degrees or not printed on the sheet at all. To print it correctly, the pdf must be oriented in portrait mode.
My thoughts so far:
Any other ideas or suggestions?
I have solved this problem. Turns out, in the context of the addwatermarkfromfile command, the bfixedprint parameter when true will force the watermark to be printed in a specific orientation every time. If you make this value false, you can rotate the watermarks with the PDF.