Excel VBA and Macro Programmer
- or -
Post a project like this£100(approx. $124)
- Posted:
- Proposals: 2
- Remote
- #34629
- Expired
Description
Experience Level: Intermediate
We require a person with excel expertise to program either macros or program in VBA to process and automate data for reporting functions.
We have a Building Management Software package that is linked to an Excel file via DDE link (Dynamic Data Exchange) The building management software is outputting counters that are triggered every second, these counters are reset to zero every Sunday night at midnight.
We need a Macro or VBA program, run at 23:59 every Sunday to copy the data from the existing Excel file every week and paste it into a new excel file, without closing the original file.
This file then needs to be saved with the date in the file name, the important part of the pasting process is that the DDE links are broken in the pasted information.
If the DDE syntax remains in the pasted information this will automatically set up a live link to the Building Management Software and when the counters are reset the data will be lost, so this is an essential part of the software Marco.
Once we have the data pasted into the new file we need some graphs produced automatically from the data, the automatic graphs then needs to be emailed to our management team automatically and weekly.
We have a Building Management Software package that is linked to an Excel file via DDE link (Dynamic Data Exchange) The building management software is outputting counters that are triggered every second, these counters are reset to zero every Sunday night at midnight.
We need a Macro or VBA program, run at 23:59 every Sunday to copy the data from the existing Excel file every week and paste it into a new excel file, without closing the original file.
This file then needs to be saved with the date in the file name, the important part of the pasting process is that the DDE links are broken in the pasted information.
If the DDE syntax remains in the pasted information this will automatically set up a live link to the Building Management Software and when the counters are reset the data will be lost, so this is an essential part of the software Marco.
Once we have the data pasted into the new file we need some graphs produced automatically from the data, the automatic graphs then needs to be emailed to our management team automatically and weekly.
Stephen S.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
25 Apr 2024
Ireland
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