Forum Discussion

sarya's avatar
sarya
Frequent Contributor
16 years ago

Script Code not opening .xlsx files

Hi, I need to work with .xlsx files.I am using this code to open .xlsx files.It opens .xls files perfectly fine but not .xlsx files. In the local directory ,it creates a temporary .xlsx file al...
AlexeyKolosov's avatar
AlexeyKolosov
Icon for Staff rankStaff
16 years ago

Hi Sumedha,


Add the following line after 'var oSheets;' - this can help you see an error message if it is displayed:




oExcel.Visible = true;


For more information, refer to the 'OleObject Property' help topic. If this suggestion does not help, please let us know which version of Excel you are using and send us the file you are trying to open.