Run method for excel macro in javascript

Question

0.00/5 (No votes)

See more:

Hey
I want to run excel macro from Javascript code. I find run method in VB but when I tried the given statement in Javascript code, it's giving error: already I have opened that particular excel which has macro.

Excel.Run(Macro name,null)

As macro don't require any parameter that's why I pass null in it.

If I write:

Excel.Run(Macro name)

It again gives me an error.

Please, can anyone help me?
Thanks in advance.

Posted 13-Mar-11 3:02am

Farah Siraj

Updated 13-Mar-11 3:08am

Sandeep Mewara

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2011-03-13T03:38:00

Solution 1

AFAIK, you cannot run anything in Excel from Javascript: that would require giving the webpage access to the Client software and data.

Not a good idea - you can see what use would be made of it by the script kiddies.

Posted 13-Mar-11 3:38am

OriginalGriff

Farah Siraj · Answer 2 · 2011-03-21T05:20:00

yeah i have found that we can run excel macro from javascript very easily. The code is

MIDL

Excel.Workbooks.Open(file path name);
 Excel.Visible = true;


Excel.Run(macro name);

here "macro name" means full name of macro for example if macro is in excel file named as Book1.xls and in the Module1 and let say macro name is Test so we will write as

C++

Excel.Run("Book1.xls!Module1.Test)