I have this code:
<html>
<script type="text/javascript">
function test() {
var Excel = new ActiveXObject("Excel.Application");
Excel.Workbook.Open("teste.xlsx");
}
</script>
<body>
<form name="form1">
<input type=button onClick="test();" value="Open File">
<br><br>
</form>
</body>
</html>
So the main problem is I keep getting this error:
On line 7 , Unable to get value of property Open
URL file:///C:/users/admin/desktop/test.hta
Firstly, try moving your script to the bottom of the body. You should also set your Excel
variable to be visible. And there's a typo with the line Excel.Workbook.Open("teste.xlsx");
(should be Workbooks
). The following is working for me in IE. I don't think it will work in other browsers:
<html>
<body>
<form name="form1">
<input type=button onClick="test()" value="Open File">
<br><br>
</form>
<script type="text/javascript">
function test() {
var Excel = new ActiveXObject("Excel.Application");
Excel.Visible = true;
Excel.Workbooks.Open("teste.xlsx");
}
</script>
</body>
</html>
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With