Runtime Error opening Excel Spreadsheet
When I run this code, I get intermittent runtime errors: var Excel ; Excel = Sys.OleObject("Excel.Application") ; Excel.Workbooks.Open("F:/my_spreadsheet.xlsx").Worksheets("Even T...
Forum Discussion
YMinaev
Staff
StaffHi,
What is in the 'fileName' variable? Also, what happens if you execute the two lines shown on the screenshot from an external JS file. You need to modify them firsts like this:
Replace <value> with the exact path to your file (the 'fileName' value).
What is in the 'fileName' variable? Also, what happens if you execute the two lines shown on the screenshot from an external JS file. You need to modify them firsts like this:
var Excel = new ActiveXObject("Excel.Application");
Excel.Workbooks.Open(<value>);
Replace <value> with the exact path to your file (the 'fileName' value).