Excel VBA and Macro Programmer

  • Posted:
  • Proposals: 2
  • Remote
  • #34629
  • Expired
Excel Gurus ..Sergey M. have already sent a proposal.
  • 1


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.

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.