I am creating a button for people to easily to print an entire sheet. However, I have an issue in regards a macro i am using to copy an entire sheet to a png/pdf file.
The macro i am using is:
ActiveDocument.ActiveSheet.ExportBitmapToFile "C:\Users\Administrator\Desktop\Pending Faults **where current date needs to be**.png"
I am in the process of transferring some of my Excel reports into Qlikview. For those in my team who use the report, they don't have to worry about the naming convention and the location to copy too, it's all done for them at the click of a button. The Excel macro i use is:
If you want the user to enter the path dynamically, you can use variables in front end. I have attached a sample for your reference. Also, you can find the API guide in below link. You can search qlikview macro examples and syntaxes easily. Good luck.