File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes HTML, CSS and JavaScript and the fly likes Excel macro and javascript Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » HTML, CSS and JavaScript
Bookmark "Excel macro and javascript" Watch "Excel macro and javascript" New topic

Excel macro and javascript

amey mahadik

Joined: Mar 27, 2008
Posts: 8
I am able to open an excel sheet using javascript and now i want a macro to run as soon as the excel sheet is opened.
I have used Auto_Open() and it runs fine when i open the excel sheet manually but when i open the sheet using javascript the macro does not run at all.

Here is the javascript code i have written to open the excel file.

function openExcel(){

var Excel; // Declare the variables
Excel = new ActiveXObject("Excel.Application");
Excel.Workbooks.Open("C:/Final templates/MyExcel.xls");
Excel.Visible = true;

Is there a way to run this macro..?

I agree. Here's the link:
subject: Excel macro and javascript
It's not a secret anymore!