Hi,
I am new to VBA, and have written some simple code that pulls some information out of a SharePoint 2010 list view, and makes some simple calculations within an Excel 2010 table. I have then written a number of individual subs that use the table to prepare a single Pivot Table each. The Pivot Tables are used for adhoc reporting and so I never need more than one Pivot table as I copy it out into an email.
Each of these individual elements works fine, but I would like the first macro, PopulateData(), to prepare the table and then pop up a window which asks which Pivot Table I would like (MissedDeadline(), Overdue() etc), upon selection it would then run the chosen macro and present the pivot table.
Any help would be greatly appreciated.
Kind Regards,
Simon
I am new to VBA, and have written some simple code that pulls some information out of a SharePoint 2010 list view, and makes some simple calculations within an Excel 2010 table. I have then written a number of individual subs that use the table to prepare a single Pivot Table each. The Pivot Tables are used for adhoc reporting and so I never need more than one Pivot table as I copy it out into an email.
Each of these individual elements works fine, but I would like the first macro, PopulateData(), to prepare the table and then pop up a window which asks which Pivot Table I would like (MissedDeadline(), Overdue() etc), upon selection it would then run the chosen macro and present the pivot table.
Any help would be greatly appreciated.
Kind Regards,
Simon