Link to home
Start Free TrialLog in
Avatar of RagavanSP
RagavanSP

asked on

Python Vs VBA Script

Hi Experts,

         How can I use Python Script instead of VBA Script in Excel or Word Application?.
         Pls Explain with an Example.

Cheers,
Ragavan.
Avatar of F. Dominicus
F. Dominicus
Flag of Germany image

Avatar of dwdbah
dwdbah

That example answers the reverse question - how can I use Excel in Python.

The simplest way I could answer the question posed, however, would be to use Python to write COM objects, which you then call from a small VBA wrapper.

As for an example, just have a Google about for writing COM servers in Python.

Dave.
Yeah I think I missed something. Sorry.

Friedrich
I think the thing I'm missing is why? I like python, but I wouldn't use it instead of VBA unless I had a very good reason. Perhaps it's a homework question.
SOLUTION
Avatar of F. Dominicus
F. Dominicus
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RagavanSP

ASKER

Hi DominicCronin and All,

     I need it becoz My boss has asked me to learn Python. We are going to use Python instead of using VBA. Even i am not aware of VBA also. They told Python is easy to use.
     So I need a start on that. I dont know where,how to start and where to write the Python script(in place of VBA).

     Or else just tell me how to perform a cumulative addition in a praticular column in Excel.

Cheers,
Ragavan.
   Or else just tell me how to perform a cumulative addition in a particular column in Excel   USING PYTHON .

Cheers,
Ragavan.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
RagavanSP - are we meeting your needs? Do any of the answers tell you what you want? Do you have further clarification or questions?

Please accept an answer or tell us what yuo need. Bob Gailer, page editor.
Thanks a lot to all....

Sorry for the delay...

Ragavan.