It's not a secret anymore!
The moose likes HTML, CSS and JavaScript and the fly likes Excel macro and javascript Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Engineering » HTML, CSS and JavaScript
Reply Bookmark "Excel macro and javascript" Watch "Excel macro and javascript" New topic
Author

Excel macro and javascript

amey mahadik
Greenhorn

Joined: Mar 27, 2008
Posts: 8
Hi
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..?

Thanks
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Excel macro and javascript
 
Similar Threads
unable to open excel document
Read MS Excel Sheet Formula Execution Value Without Opening it
Problem in reading the excel file path from WINDOWs machine from UNIX environment
Problem with macros in excel sheet
Reading calculated values from Excel