I need a script to launch an Excel Macro every X seconds within a specific workbook.
Please don't bid if:
You are not sure how to handle the constraints listed below,
You don't explain the basics of how you intend to build the script in your offer.
The script must ensure that the following constraints are met:
-Excel must be usable between each launch of the macro. The sheet should be editable between each launch.
That is why I don't think about using VBA.
-Excel must not necessarily be the active window for the macro launched to work:
the script should manage to launch the macro every X seconds without requiring to make Excel the active application if it is not.
That way, other applications can be used while the macro is launched in Excel in the background.
-If multiple instances or Excel or workbooks are running simultaneously the script should launch the macro only for the specific workbook in which the macro is.
-The script should be documented
The macro is very simple, it is named "RefreshAll" and is located in "modules"
' RefreshAll Macro
' Keyboard Shortcut: Ctrl+t
[login to view URL]
21 freelancers are bidding on average $136 for this job
Hi, As you could see on my profile I develop most of projects in python. It is no problem for me to deal with your requirement. Looking forward to discussing in chat. Regards, Liu
This can be achieved in python using [login to view URL] library in python . Please let me know on +919840116199 (whatsapp) , if you are ok with this approach.
I might be having the solution readily available; Can you please share the details regarding the macro enabled Excel file, so that I can provide you the solution. Thanks!!