Export straight table data in to Qvd

[ashok1203]

Hi All,

I need a small help. I have created a report in the QV application. i want to export that report data automatically everyday into a QVD. I have written one macro for this after post reload action. I am getting the QVD but with a limited set of rows i.e. 65536. I need all the data into a QVD. can any one help me on this.

[ashok1203]

Hi Digvijay Singh, I tried that method also but it is not working for me.

[ashok1203]

Ok Thanks Avinash for your better suggestions.

[Digvijay_Singh]

Did you make the change as suggested -

WB.SaveAs "c:\temp\"&strvPCT&" - A&C Data.xlsx", 51

also as mentioned somewhere -

It's possible the .SendToExcel method also is limited to 65536 rows. In that case you can try increasing the easter egg setting RowLimitForCsvInsteadOfXls. See here for how to do that. Maybe that helps. If not, you're probably limited to exporting to a .csv file instead of to .xlsx.

Solution given by - gwassenaar

[avinashelite]

If you have got the answer please mark the correct and helpful answers

[ashok1203]

It was working fine for me. but the rows should divided into N no.of sheets. Each sheet can consists the record values of 65536 continuously.