J
J Wait
How do you print to pdf in VBA and tell it where to save the pdf file and
what to name the pdf file. I can save as pdf in vba, but this does not pdf
the file correctly (different tabs save as different sizes in pdf and it's a
mess). Only printing (not saving) to pdf does it correctly.
When I record myself, it records:
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"
what to name the pdf file. I can save as pdf in vba, but this does not pdf
the file correctly (different tabs save as different sizes in pdf and it's a
mess). Only printing (not saving) to pdf does it correctly.
When I record myself, it records:
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"