Lukket

Loading a ADD-in in excel using Python issue (Bid <30$)

I am trying to run a macro in excel using python.

The issue is that the macro needs a add-in (.xla file) which needs to be loaded before the macro runs.

This add-in does not get loaded everytime, when the python code runs and tries to run the macro.

So as a solution, I need to unload and load the addin using python, as we do in excel to load the addin

I am trying to do this

import [login to view URL]

xl = [login to view URL]('[login to view URL]')

[login to view URL] = True

addin_path="C:\\Path\\[login to view URL]"

xl.DisplayAlerts=False

[login to view URL]('C:\\Path\\[login to view URL]')

#Unloading and loading the add-in

[login to view URL](addin_path).Installed=False

[login to view URL](addin_path).Installed=True

#Running the macro "Macro_run" in the Excel file

xl.DisplayAlerts=False

[login to view URL](Filename="C:\\Users\\[login to view URL]")

[login to view URL]("Macro_file!Module1.Macro_run")

xl.DisplayAlerts=False

[login to view URL]()

[login to view URL]() # Comment this out if your excel script closes

del xl

But it gives me this error

"Microsoft Excel', u'Add method of AddIns class failed'

in this line:

[login to view URL](addin_path).Installed=False

How to rectify this

Evner: Excel, Python

Se mere: we can't load this add-in because we couldn't connect to the catalog, word add-in not loading, error loading add-ins, office 365 error loading add-ins, error loading add-ins excel, excel add in not loading, add-in error outlook 2016, error loading add-ins word 2016, export mysql excel using php, export datatable excel using vbnet, visual basic instalar add excel, getting average excel using vbnet, read csv file using python script, name sheets excel using vbscript, write excel using php, copying cell excel using visual basic, download excel using vbscript, data excel using cnet, integration database testing tools using python, loading csv access using excel vba

Om arbejdsgiveren:
( 28 bedømmelser ) new york, United States

Projekt ID: #17212053

2 freelancere byder i gennemsnit $19 på dette job

cranius

Before creating the Excel application, copy the addin to: C:\Users\(username)\AppData\Roaming\Microsoft\Excel\XLSTART Then it will automatically load.

$10 USD in 0 dage
(9 bedømmelser)
3.5
NSDataGeeks

Hi we could do this for you in a day. Our team consists of individuals from diversified fields and each of us having more than 5 years of experience in python. For more details check out our profile. Relevant Skills a Flere

$27 USD på 1 dag
(0 bedømmelser)
0.0