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