Excel Query

Completed Posted 3 years ago Paid on delivery
Completed

I have a few hospitality related businesses and use Excel to integrate with other applications. I have taught myself VBA but am far from an expert and quite often need assistance in solving problems/issues such as the following.

I have some VBA code in Workbook 1 to query data in another external workbook (Item [login to view URL]) and it works perfectly. I have copied the code into another workbook(Workbook 2) but when I run it , I get a "Run-time error 1004"" at the 4th last line of code as per the following:

.[login to view URL] = "Table_Query_from_Excel_Files"

.Refresh BackgroundQuery:=False

End With

End Sub

Regards

Mark

Visual Basic for Apps Excel Excel Macros Excel VBA

Project ID: #27934699

About the project

36 proposals Remote project Active 3 years ago

Awarded to:

P0L

(479 Reviews)
8.0

36 freelancers are bidding on average $41/hour for this job

schoudhary1553

Hi, Greetings! ✅checked your project details: Excel Query ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking f More

$35 AUD / hour
(447 Reviews)
8.3
ilkecokay

Hello. I can help with that. I am an expert on the subject. Please message me so we can chat. regards.

$35 AUD / hour
(94 Reviews)
6.0
zu02

Hi As you know vba then you will know also that in Excel to code queries are two ways: to use power query and to code by vba with sql/ado . In my several Excel projects here I've used sql/ado vba method. Send me your E More

$35 AUD / hour
(31 Reviews)
5.9
dhanrajkarthick

Hi there, I can help you to fix the issue. I am a Microsoft Certified Professional in Excel and VBA as an Expert. Awaiting your response. Regards, Karthick G.

$35 AUD / hour
(44 Reviews)
5.3
ShivaniGoyalsai

Hi Mark I have 10+ years of experience in vba programming and database management. I checked the requirements and will resolve your issue right away if given chance please connect via chat to get started t More

$39 AUD / hour
(42 Reviews)
4.6
arunkumar9896

I can perfectly help you with that. I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Google sheets & Excel (including VBA and Macro) to per More

$50 AUD / hour
(13 Reviews)
3.7
RavenSolutions

Hi! I have went through about your project Excel Query I am KickAss in Excel VBA, Excel, Visual Basic for Apps and Excel Macros, so I'am totally sure I can deliver Your project ! Please contact me to discuss more about More

$35 AUD / hour
(2 Reviews)
2.9
arunodaya123

HI hope you doing well, I am qualified and experienced senior VBA/RPA Developer having 12+ years of experience in developing automation projects. I has done tons of projects similar to your requirement using VBA,RPA,e More

$43 AUD / hour
(7 Reviews)
2.9
FreelancerKuba

Hi! Just a blind guess - your sheet is not activated when you try to do some operations on it. I would need to see the full code before I am able to give you a proper advice. I would be glad to proceed with that. Be More

$35 AUD / hour
(2 Reviews)
2.3
pauldedumo

Trust you've been well these days! Hi! My name is Ryan, a tool developer by profession. I've had years of experience creating excel reports by pivots and tool automation using vba. I would love to discuss with you ho More

$35 AUD / hour
(0 Reviews)
0.0
nikunj1985

hi. I am available and interested to do this job. I have 15 years of work experience in operational management handling business from North America. thank you.

$44 AUD / hour
(0 Reviews)
0.0
kinjal16101990

Hi, Greetings! checked your project details: Excel Query Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a tr More

$35 AUD / hour
(0 Reviews)
0.0
denalekskhua

Hi Can we discuss? I hope to check your whole code. I think I can help you with my skills, assure. Please contact me then we can discuss more. Best wishes.

$43 AUD / hour
(0 Reviews)
0.0