macro pivot to excel with format as biff

[warfollowmy_ver]

Hi all!

How do it? Creating excel file through macro from pivot with format as biff.

[tamilarasu]

Could you post a sample application?

[warfollowmy_ver]

I have two pivot tables.

It is necessary to insert them into Excel sheet and a lower second.

I put the first pivot through macro, define the number of lines in the first pivot and following in Excel file into a second table under the first table. But the format needs a biff.

That is a normal export will not do.

[tamilarasu]

Fine. Could you post a sample file with what you have done (Macro) so far. It will be easy for me to help you further.

[warfollowmy_ver]

Ready. Reworked to not shine data...

[Anonymous]

Hi,

I've searched on Macro tutorial

sub Export()

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportBiff "C:\Qlikview\test.xls"

end sub

Best regards,

Cosmina

[tamilarasu · Accepted solution]

Kindly check the attached file and let me know If any issues.