Write C# automation for Excel spreadsheet with macros
- or -
Post a project like this4167
£25/hr(approx. $31/hr)
- Posted:
- Proposals: 2
- Remote
- #180973
- Awarded
Description
Experience Level: Expert
I have an Excel XLSM containing some macros in VBA. This spreadsheet has a button that shows a hidden sheet, then allows the input of some parameters into some named ranges. Then another click button calculates some results. I would like some C# automation written that allows this to be called unattended on a specially set up windows 7 desktop with Excel 2010 installed (I will do this). Your delivered code needs to demonstrate (as a console app) that it can take a number of parameters (probably as XML), open the work sheet, "click" the "start" button, "write" to the cells with the values, "click" the "Go" button then when the macro has completed running save the ranges to a new spreadhseet (filename specified in input parameters). The spreadsheet contains all the macros in vba, they are secured with a simple password but I have this.
John S.
100% (4)Projects Completed
6
Freelancers worked with
6
Projects awarded
27%
Last project
28 Jul 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies