I want to print a file to pdf with the file folder and name referenced to certain cell values.
Am trying to get this to work:
G1 contains the folder with the formula: =h10 & "/"
H1 contains the file name with formula: =e6
If I use saveLocation = "C:/Users/bobby/desktop/folder/file.pdf" it works so I guess the issue must be the cell references.
Can anyone help me please?