Quick fix required for some VBA / SQL code
4659
£40/hr(approx. $50/hr)
- Posted:
- Proposals: 2
- Remote
- #79502
- Archived
Description
Experience Level: Expert
I have an excel spreadsheet installed at a client's office which draws data from an SQL table and populates various rows in a spreadsheet. The code works fine on my machine and everyone elses, but not on the client's. I've tried to fix remotely, but have not suceeded. The problem is with this bit of code:-
Set g_cnnConn = CreateObject("ADODB.Connection")
g_cnnConn.CursorLocation = 3
g_cnnConn.Open = strConnectionString
Attached is a word doc illustrating the problem.
This is fairly urgent and would be a very easy job for someone with the appropriate knowledge. Please feel free to bid as I have no idea what the price should be!
Set g_cnnConn = CreateObject("ADODB.Connection")
g_cnnConn.CursorLocation = 3
g_cnnConn.Open = strConnectionString
Attached is a word doc illustrating the problem.
This is fairly urgent and would be a very easy job for someone with the appropriate knowledge. Please feel free to bid as I have no idea what the price should be!
James P.
100% (8)Projects Completed
14
Freelancers worked with
13
Projects awarded
50%
Last project
23 May 2022
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