ExportBiff exports 100 first rows only

[#1]

Hi Community.

Need some help with function ExportBiff. I'm using this function in macro with straight table, and found an issue, that it exports only first 100 rows from table (which containes 500 rows).  How to fix this or where to change this limit? Any help would be appreciated.

Thank in advance.

[rubenmarin · Accepted solution]

Hi, I don't have that limit, using ExportBiff creates an xls with several thousands of rows, I also tried with a simple example:

Sub TEST

set obj = ActiveDocument.GetSheetObject("CH18")

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

End sub

Created test.xls with 4180 rows. Check if the table you're exporting has a dimension limit or any other limit in the object itself.

[#3]

Thank a lot, Ruben.  Really, I have  complex expression as row count limit in chart , and it was the root cause of issue. Thanks for your time.