export Pivot table in biff format

[rohit214]

Hi alll,

I am using QV9 sr7 when i am exporting pivot table through macro (on reload) so its comes in ooxml format

i want exported file should be in biff format.

Thanks&regards

rohit

[rohit214]

any one.....

[Jason_Michaelides]

Check the export section of user preferences.

[rohit214]

hi jason,

i alredy checked that option here i attached the screen shot please find the attachment an dguide me

thanks&regards

rohit

[Jason_Michaelides]

Can you please post your app.

[rohit214]

HI

in my appication i am  exporting pivot table into excel its working fine but it changes the format

from biff to ooxml if i am exporting pivot table manually at that time the format is biff only

please find the attachment

Thanks&regrads

rohit

[rohit214]

any other option....

[Jason_Michaelides]

Sorry - I'm not really sure about this.  I have previously used

	set obj = ActiveDocument.GetSheetObject("CH01")
	vFilename = "C:\MyFile_" & getVariable("FileName") & ".xls"
	obj.ExportBiff vFilename

for exporting to Excel in a macro.

[rohit214 · Accepted solution]

hi

its not working

thanks

rohit