Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table that filter the datas trought 3 macros. How could I write a macro that export the 3 results into a xls file?
Thanks for help
Gimo
Did you try this?
1. Create a button.
2. Add to its Action an External Action type : Export.
3. Setup the action as required:
a. select the fields as needed
b. mention the path to save the excel. By default it would say, .qvo. Replace it with .xls
c. do the number formatting if needed.
d. Ok, Ok
4. Click the button.
5. Check the path you have mentioned earlier.
Do tell if this suffices or not.
'To Excel Generate
set obj = ActiveDocument.GetSheetObject("CH703")
obj.ExportEx "E:\Qlikview\Prima\PPT\Department_Loadinng.xls",5
set obj = ActiveDocument.GetSheetObject("CH704")
obj.ExportEx "E:\Qlikview\Prima\PPT\Top_5_Project.xls",5
set obj = ActiveDocument.GetSheetObject("CH705")
obj.ExportEx "E:\Qlikview\Prima\PPT\0HrsProject.xls",5