
SQL - Excel Macro
- or -
Post a project like this35
£40/hr(approx. $54/hr)
- Posted:
- Proposals: 19
- Remote
- #4375564
- Awarded
Senior Administrator | Experienced IT Support & Microsoft Tools Specialist | 10+ Years Industry Experience
UK's No. 1 .Net / Angular / React / Ionic Developer | 100% Customer Satisfaction Guaranteed | Top Seller on PPH


Data Modeling in Excel & Power BI With Power Pivot, Power Query, DAX and Google Data Studio Expert.

122754551192729622748042272394122259081178123740667812300230113016306329176211691946714





Description
Experience Level: Expert
Hi Hope you are well.
I have an excel with a Macro that links to SQL and does some calculations using 3 tables of data in SQL and then keeps the data in SQL in a new table.
1. this macro has stopped working due to "ADODB.Recordset" issue.
2. the macro produces monthly account balances from inception to now and I would like to adjust this to be based on a start date and not all of the history.
If you believe you can help with these two issues can you please let me know.
Many thanks
Robert
I have an excel with a Macro that links to SQL and does some calculations using 3 tables of data in SQL and then keeps the data in SQL in a new table.
1. this macro has stopped working due to "ADODB.Recordset" issue.
2. the macro produces monthly account balances from inception to now and I would like to adjust this to be based on a start date and not all of the history.
If you believe you can help with these two issues can you please let me know.
Many thanks
Robert

Robert S.
100% (11)Projects Completed
14
Freelancers worked with
15
Projects awarded
38%
Last project
6 Jun 2025
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Can you share the workbook for clarification of the work involved.
1130487
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