Excel 2000

[dtrom26]

Hi

Hoping someone can help. I have the following code running in a MS Excel file running off MS Excel Professional Plus 2016. However, I am now trying to run this code in Excel 2000 but it keeps failing. Please can anyone help and modify the code to suit Excel 2000. I am not a programmer and managed to find most of the code below online.

Unfortunately I am stuck with Excel 2000 for this purpose as this is the only license we have on the machine I want to run it from.

Thanks

"Sub Open_HTML_Save_XLSX()
Workbooks.Open Filename:="C:\Users\NICK_3\Downloads\RATIOS.HTML"
ActiveWorkbook.SaveAs Filename:= _
"C:\Users\NICK_3\Downloads\RATIOS2.XLSX", FileFormat:= _
xlOpenXMLWorkbook
ActiveWorkbook.Close
End Sub"

 

[MARK858]

You can't open a xlOpenXMLWorkbook (.xlsx) in 2000, it has too many rows and columns.
You need to convert the file to a xlExcel8 (.xls).

 

[dtrom26]

Thank you for your help. Could someone please help me modify the code for Excel 2000? I am not a programmer and have no idea where to start

Thank you so much.

 

[MARK858]

It is not the code it is the type of file... you can't open a file which holds a million+ rows and a thousand + columns with a program that can only handle 65000+ rows and 256 columns.
You need to open the file in the later version (on the works computer) and then save it as a xls (the older version) then change the code to Excel8.