Hi is there a way for Macro to run when user clicks the jet report run button
I cannot seem to find a way for this one
My issue is that users want their data to be on a pivot-table and it has lots of data i have to use the sheet function from jet report the problem is since it is a hinderance to filter each sheet i have to use VBA the problem is that when i hit run on jet report it does not run the macro automatically is there a way for this one ?
Can someone help or assist on this one
Date
Votes
3 comments
-
Lord John Lee Hi i get your point on this one but the problem is that the sheets needs to be filter if iam going to do that way it will just follow what ever was the format of the first sheet, and there are different names to be filtered and show the resulting values i need for those sheets
-
Jet Central 365 I would not advise your to use any Macro for this.
If the user want a pivot table use =NL(Table) / The Table Builder then use NL(Sheet) to perform pivot table replication.
If you need to filter each sheet, you report might not be properly designed.Jet Central 365
Your Jet Reports & Jet Analytics Partner.
For all your Jet Reports & Jet Analytics consulting services : sales@jetcentral365.com
-
Marc I don't think you can re-code the Run button, but you can get VBA to press the run button for you...
Application.Run "JetMenu", "Run"
Then the rest of your VBA will start start once Jet has finished.
Please sign in to leave a comment.