Closed

VBA To Import Excel Files & Run Some Manipulations

I have some vba code that imports two excel files into access tables then creates an access table to house the data in the format that I need. The issue that I have is that sometimes one of the updates does not update properly leaving 60+ minutes of manual labor to manually look up the values and input by hand.

I need someone to fix this issue with the VBA and see if there are any optimization techniques avaliable and re-write the code for that.

Skills: Excel, Microsoft Access, Visual Basic for Apps

See more: vba script import csv files access, import data closed excel files vba, a program i can run large excel files to identify certain values, vba import module programmatically, excel vba import data from another workbook without opening, excel vba import worksheet from another workbook, vba import excel file, excel vba import data from another excel file, excel macro import data from another workbook, vba copy code module programmatically, excel vba import sheet from another workbook without opening, vba code to import data from website to excel, how to import data from notepad to excel using vba, how to import altium files into allegro, how to import illustrator files into indesign, vba code to import data from excel to access table, how to import audacity files into itunes, how to import php files to wordpress, how to import multiple text files into excel on one worksheet, how to import multiple text files into excel on one worksheet vba

About the Employer:
( 2 reviews ) Athens, United States

Project ID: #27508430

35 freelancers are bidding on average $26 for this job

(946 Reviews)
8.1
VladimirLilenko

Hello! I am ready to update your code. You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko?w=f From the Microsoft Access, Excel and vba, of course, familiar. Regards, Vladimir

$30 USD in 1 day
(210 Reviews)
6.8
finecodervw

Hi, I am well versed with VBA programming in Excel as well as MS Access. It would help if you can please share the files you are having. Looking forward to your response. Thanks

$50 USD in 1 day
(115 Reviews)
6.4
dpune

Hi, I have more than 14 years of Excel/VBA exp. Let us discuss more details so that I can estimate cost and time better. I have completed more than 320 projects. Please look at the feedback left by my employers More

$45 USD in 7 days
(117 Reviews)
6.2
narsim3128

NOTE : I HAVE EXPERTISE IN EXCEL AND VBA. I CAN COMPLETE THIS TASK IN QUICK TIME. With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT expe More

$60 USD in 2 days
(60 Reviews)
6.0
expertcoder1vw

Hi, I'm an Access / Excel / VBA expert and can fix the VBA code and improve it where possible for you. Can deliver in 2 days or less. Good quality work done. Thanks for considring my bid. Bests, Steve

$50 USD in 2 days
(39 Reviews)
5.7
writingapp

Hi. I have written many automation VBA macros. Ready to write your project. Will complete within 1 day

$30 USD in 1 day
(61 Reviews)
5.4
VBAautomation

Hi, Hope you are doing well. I am developing MS Access and SQL server database since 2009 and I have excellent command on database designing and programming. I can rebuild the functionality and update the existing pro More

$50 USD in 1 day
(28 Reviews)
5.4
dhanrajkarthick

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

$30 USD in 2 days
(30 Reviews)
4.8
maguirrer

Hello, I can help you to fix the macro to convert and import all the files, please send me a message with more details and if its possible with the files that you are getting this problem, so I can check it and will st More

$22 USD in 2 days
(37 Reviews)
4.3
chintuag

Dear Hiring Manager, I have experience in Access and VBA and have developed projects and would like to offer my expertise for your project. My expertise includes, but not limited to, User Forms, Dashboards, VBA, We More

$30 USD in 3 days
(8 Reviews)
3.9
hafsahkhan04

Hey, I hope you are doing well. I am experienced in this field. I have excellent command over MS Excel (You may check reviews on my profile for my past work)  I would be able to provide you high quality and quick servi More

$30 USD in 7 days
(2 Reviews)
3.8
kayarshadi

Hi, I am an Excel , Access, VBA , Power BI expert. Please tell me more about your project in details(which file has problem and which problems) and send me the files. Best Regards Kayvan Arshadi

$20 USD in 2 days
(7 Reviews)
3.3
mahfuzrahaman

I am well versed with VBA programming in Excel as well as MS Access. It would help if you can please share the files you are having. Please send me a message we can more discuss about this project. Thank you. Mahfuz

$15 USD in 1 day
(2 Reviews)
3.5
dataEntryExperty

I will do it for you. How much time do you have. Please let me know if more details on chat. Already completed many projects

$30 USD in 1 day
(13 Reviews)
3.5
khaldalfalah

Hi, I am ready to work on your access vba, please give me more details about the requirements. I have experience in MS SQL server, asp.net, crystal reports and VB.net more than 13 years. Other skills: Access vba, Exc More

$30 USD in 2 days
(10 Reviews)
3.2
ShakeelASESE

I am working as a Data Scientist with Python, Matlab, Excel, SAS, STATA, SPSS, and R, Predictive Modelling, and Statistical Modeling using Machine Learning and Deep Learning Algorithms in these fields. I have done many More

$10 USD in 7 days
(1 Review)
2.6
alokes

HI, I AM A SOFTWARE PROFESSIONAL DEVELOPING SOFTWARE IN MS ACCESS WITH VBA FOR LAST 22 YEARS. I HAVE UNDERSTOOD YOUR REQUIREMENTS AND WOULD LIKE TO DEVELOP THE DATABASE IN MS ACCESS AS PER YOUR REQUIREMENT AND INPUT PR More

$30 USD in 1 day
(10 Reviews)
3.8
ShivaniGoyalsai

Hi I have 10+ years of experience in VBA programming, database management and worked many related projects in the past. I am ready to carry out all kinds of automation work in VBA, Excel, Ms-Access (writing queries , More

$15 USD in 1 day
(2 Reviews)
2.2
MKProdip

Hi, I am Sondip Moral..Data entry expert.. I have Good knowledge about excel formulas and functions.. I can complete your job perfectly as your requirement.. Please contact me lets discuss over chat even the price.. More

$10 USD in 7 days
(4 Reviews)
1.8