Modify Excel VBA that Downloads data from Access Queries

$10-30 USD

Completed

Posted

almost 9 years ago

$10-30 USD

Paid on delivery

I have an excel macro that downloads multiple access queries and then dumps the data into a corresponding excel sheet. i can share the code to the selected bidders. Right now the code dumps the data to cell A1 by default. I need the code modified so that i can dump the data into a cell i define in the vba code. thats it. pretty simple. here is a snippet of the code... Sub DownloadQuery() On Error Resume Next Dim cn As [login to view URL], rs As [login to view URL], r As Long Dim db As Database ' connect to the Access database Set cn = New [login to view URL] [login to view URL] "Provider=Microsoft.ACE.OLEDB.12.0; " & _ "Data Source=C:\Users\tmont\Google Drive\Kokua\DT\ForecastProd [login to view URL];" ' open a recordset Set rs = New [login to view URL] With Sheets("config") configrow = 1 Do While .Cells(configrow, 1) <> "" If .Cells(configrow, 2) = "Y" Then qryname = .Cells(configrow, 1) With Sheets(qryname) [login to view URL] qryname, cn, adOpenKeyset, adLockOptimistic, adCmdTable If [login to view URL] = 1 Then If [login to view URL] > 0 Then For i = 1 To [login to view URL] .Cells(1, i).Value = [login to view URL](i - 1).Name 'fields is a 0 based collection Next i rownum = 2 Do While Not [login to view URL] For i = 1 To [login to view URL] .Cells(rownum, i).Value = [login to view URL](i - 1) 'fields is a 0 based collection Next i

Excel

Microsoft Access

Project ID: 8173234

About the project

19 proposals

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@watersev

Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene

$15 USD in 0 day

5.0

(40 reviews)

4.6

19 freelancers are bidding on average $21 USD for this job

@paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).

$30 USD in 1 day

4.8

(62 reviews)

5.6

@sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will deliver flawless work. I am very much able to work on this. ***I am ready to start Waiting for further discussion.. with thanks and regards

$29 USD in 3 days

4.5

(41 reviews)

5.5

@kevivu

Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Budgeting, estimation, Software development, SDLC, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Expert in MS office, which includes formatting, powerpoint presentation, mail merge, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers.

$30 USD in 1 day

4.9

(25 reviews)

4.7

@abhinovpankaj

Hello, I have been working with a MNC based company since last ~ 4 years, as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. I have worked in past for you on other projects . Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov

$30 USD in 1 day

5.0

(11 reviews)

4.2

@coolomar1998

Feel free to contact me toModify Excel VBA that Downloads data from Access Queries . Budget is not any issue as well.I have team for quick and quality results. We can manage each and everything via private messages. Take a look on my 5 start feedback work.

$25 USD in 0 day

4.7

(12 reviews)

3.9

@jschaffranek

I am a software developer with 10+ years experience. I am currently consulting for a Fortune 50 company doing work primarily in Access and Excel with VBA. I have extensive experience in other aspects of software development as well. I am employed full-time, for the last 5 years, doing .NET development. I have built several large enterprise solutions during this time. I am very knowledgable in the following: .NET, VB, C#, HTML, javascript/jQuery, SQL, Access, Excel, VBA, Flash, Actionscript, PHP. I am new to Freelancer but am trying to build a solid profile. If you would like to talk before awarding this project let me know. Hope to hear from you.

$18 USD in 1 day

4.9

(7 reviews)

3.5

@AccuPro

Hello, As I see it now, you have the system set up so that you place a query in your first row and the result is populated in the second row. Where would you like your other queries to be stored? And where would you like to get the data? I suggest you place your queries in the FIRST column and get DATA beginning in SECOND column onwards. That way you can place any number of queries in the rows of the first column. Best regards, AccuPro.

$25 USD in 1 day

4.7

(6 reviews)

3.3

@lxqcad

This is pretty straightforward. Introduce a variable for row and column in the macro and add to the loop which writes the field names and the data into Excel Sheet. I can do it for you in 10 mins flat. Thanks for considering my bid!

$10 USD in 0 day

4.9

(10 reviews)

3.3

@envisionops

A proposal has not yet been provided

$35 USD in 0 day

5.0

(2 reviews)

2.2

@Giolisbeth

My name is Giolisbeth Cuevas , I am statistical / programmer, with over 7 years experience . I read your project and I think I can be useful to you.

$20 USD in 2 days

5.0

(1 review)

1.3

@mo5mo5

A proposal has not yet been provided

$25 USD in 1 day

0.0

(0 reviews)

0.0

@kabson01

HI DEAR . I AM SO GOOD WITH EXCEL AND WORD I WILL BE HAPPY TO WORK ON THIS JOB . I HAVE INTERNET AND MY COMPUTER . THANKS

$25 USD in 3 days

0.0

(0 reviews)

0.0

@rodweb

.....................................................................................................

$12 USD in 1 day

0.0

(0 reviews)

0.0

@LisanderPrado

Hi, I can help you with your work... It's simple to modify your code in order to the application works like you want

$12 USD in 3 days

0.0

(0 reviews)

0.0

@jrd571

I have made these exact excel macros before for my job, I'll be more than happy to help you out with your problem.

$15 USD in 1 day

0.0

(0 reviews)

0.0

@zu02

Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. I'll customize it for today... Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura

$25 USD in 1 day

0.0

(0 reviews)

0.0

@ahmedmohsen2008

Hello, Greetings from Egypt. I have excellent experience in excel, excel programming, excel vba and MS office generally. My experience will support me to achieve the assigned very easily. Thanks a lot. Kind Regards Ahmed Mohsen +2 0100 4245130

$20 USD in 0 day