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