problem after Creating and saving xlsx workbooks

[kotzo]

Hi,

I want to create a new xlsx workbook, then populate it by copying an embedded table from a word document, and then use vlookup in order to map the data with the data from another file

Everything workes until my code tried to use a table_array in the vlookup which has 300.000 rows.

Allthough (I think) I created an xlsx workbook, It seems that I' am not able to use more than 65.526 rows.

What is my mistake ?

I used the following code in order to add / save the xlsx workbook:

With Workbooks.Add
     SaveAs Filename:="temp.xlsx", FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
End With

Thanks in advance,

Kotzo

 

[Ruddles]

It worked for me, except I had to put a dot in front of the SaveAs command.

I think you have to close and re-open the workbook to see the extra rows.

What does MsgBox Rows.Count return?

 

[kotzo]

Thanks Ruddles,

it worked