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"
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"