Find Jobs
Hire Freelancers

Write an excel vba code

$30-250 USD

Slutfört
Publicerad nästan fem år sedan

$30-250 USD

Betalning vid leverans
I have this invoice spreadsheet for my etsy store. I basically want a vba code that goes into this website from the USPS ([login to view URL]), press the "Get Zone For ZIP Code Pair" tab, inputs the zip codes into the correct fields from my spreadsheet cells and returns the zone 1-digit number into another cell. Also, another VBA code that would take the every new order information from my etsy page (Name, order #, address, etc) and add it to my spreadsheet.
Project ID: 19271824

Om projektet

19 anbud
Distansprojekt
Senaste aktivitet fem år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
Tilldelad till:
Använd avatar
Hi, I can develop it on excel VBA for you in a short time. I have wide expertise scrapping on excel from web, please review the opinions from my clients about me. You only will release the payment when satisfied, so my work is guaranteed. Please send the excel and you will be happy to contracting me.
$77 USD Om 1 dag
4,9 (75 omdömen)
6,5
6,5
19 frilansar lägger i genomsnitt anbud på $142 USD för detta uppdrag
Använd avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$180 USD Om 3 dagar
4,9 (445 omdömen)
8,2
8,2
Använd avatar
I have seen the project - Write an excel vba code. I have been working in these fields((Data Entry, Data Processing, Excel, Software Architecture, Visual Basic)) for 7 yrs as a freelancer. I will never disappoint you and i will try my best to deliver good result always. Hope to work with you. Thank you.
$150 USD Om 3 dagar
4,8 (161 omdömen)
7,1
7,1
Använd avatar
Hi, Would you like to see a quick demo of your project on developing a VBA code to get ZIP Codes from USPS and to take new order information from your Etsy page completed before you award the project? You can consider it professionally done in few hours. Here is a Excel VBA project I completed pulling data from USPS. https://www.freelancer.com/projects/software-architecture/vba-code-for-zip-code/?w=f Before you award this project, I can complete a part of this project as a sample. This is so that you can be confident of the hands you will entrust this task. If you are satisfied with the result, you can go ahead and award the project. I’d love to discuss more about what would make this project a success for you. Can we have a quick chat? Thanks for your time.
$150 USD Om 3 dagar
4,9 (62 omdömen)
6,6
6,6
Använd avatar
Hi there, The requirements are quite clear and straightforward to implement so no questions really. I just need a sample file with a couple of records in so that I'd create the code with the correct target columns for zip code operation. Regarding fetching the orders from etsy, since etsy requires oauth for authentication you'll need to register for an application on etsy first and then authenticate manually only once to acquire the tokens needed. The code will handle the auth phase using the tokens from there on and fetch the order details. It'll be ready in 5 days, thanks.
$150 USD Om 5 dagar
5,0 (43 omdömen)
6,1
6,1
Använd avatar
I am postgraduate (MBA) in finance with more than 5 years of experience in advanced excel, VBA automation and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed couple of automation tools for Ernst and Young also. You can get your work done here with highest quality at lowest price. Looking forward to work with you
$130 USD Om 3 dagar
4,9 (43 omdömen)
5,7
5,7
Använd avatar
Hi. From your project declaration, its the kind of job I have been experienced well. I have been experienced in programming including Excel VBA since 2000. During 2006-2013, I had been working as a senior developer for Financial system developed in MS Access which use VBA for coding constantly. Until now, I work with Excel macro coding and gained excellent experience. I am ready to start. Hope to hear from you back soon. Regards, Alta
$150 USD Om 5 dagar
4,9 (18 omdömen)
5,1
5,1
Använd avatar
Hello. Here is one of example of working with web-forms using VBA: https://www.freelancer.com.ru/projects/visual-basic/need-import-xml-from-url/?w=f I would help you with both items, but recommend to realize second part using vb.net.
$180 USD Om 3 dagar
5,0 (31 omdömen)
4,8
4,8
Använd avatar
Hello, My name is Albert and I have a lot of experience in Excel (including formulas, macros and VBA). I have been an Excel user for many years, I have taken courses and I have learned in a self-taught way all that the courses did not teach me. In addition, I am passionate about programming (Java, C ++, etc) and, of course, I have learned and used VBA many times to adapt Excel files (or Acces) for everything I needed when Excel itself can not do it. In VBA I have done everything: advanced calculation functions, functions to customize the display format depending on each case, simple automated copy and paste functions, etc. I can not specify more about this project because I do not have more information, what I can assure you is that I can do it satisfactorily. Before saying goodbye I wanted to thank you for giving me the opportunity to bid and I wanted to invite you to visit my profile or to contact me. I look forward to any clarification. Thank you very much and best regards.
$150 USD Om 5 dagar
5,0 (7 omdömen)
3,5
3,5
Använd avatar
hi, I'm Romain, a French guy of 26 years old I can make this code for you. please contact me for more information. best regards, Romain
$94 USD Om 1 dag
5,0 (2 omdömen)
3,0
3,0
Använd avatar
Hello! I ran some testing and managed to get the Zone using the curl command and XMLHTTP Excel object from the UPS site; this is quite easy. To get the Etsy orders, we need to use the API - have you registered a developer App in Etsy and received an API key? If not, I can help you with the process. To get the current outstanding orders is by listing all shop receipts by status (open or unshipped) using the API, then extract the relevant information from the JSON response and post it to your Excel sheet, with duplicate validation (based on the order ID). I feel confident we can complete this project in 2 days - either by creating your Excel from scratch and embed the code for you to use, or work with your template. Kind regards, Andrei
$120 USD Om 2 dagar
5,0 (1 omdöme)
2,2
2,2
Använd avatar
I have 20 years in Database Developing, Programming, Training, and Accounting Solutions / Finance with Computer
$155 USD Om 3 dagar
5,0 (2 omdömen)
1,5
1,5
Använd avatar
New career Relevant Skills and Experience 2 years worked on a company
$111 USD Om 3 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
I am interested to get this job, i have experience in data entry work but in am beginner in freelancing and seeking my first bid, but i am assure you i can provide you quality work on time as desired by you. Best Regards, Waseem Khaliq
$111 USD Om 3 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
Hi, I am having 5 years of experience VBA coding & working extracting data from various tool like SAP, Webpage. I hope my profile suits your proposal. Thanks, Siva.
$155 USD Om 3 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
Dear Sir or Madam: I am interested in doing the job. I work Excel+VBA and crawling or Internet data extraction everyday I wait for your contract. Kind regards. Remote Work Guidelines of my Software Factory -We offer a personalized service. -We offer a personal dashboard for project management -We offer a full stack service of software architecture and engineering. -Expertise since 90s in business's systems -Online distance working -Extreme programming, Agile methods. Ask Portfolio Cloud services: GAE programming, Google API services Office Excel Access programming ERPs open source programming (PHP, Python) DBA, SysAdmin: MySql, PostgreSQL ASP.NET and classic programming with VS 2017 Websites Wordpress Joomla custom Access-like for buisnesses Python for ETL crawling scraping .NET VS 2017 VB.NET app SQLite DB Extract, Convert, Transform any data any format any source any target. OCR systems.
$155 USD Om 3 dagar
0,0 (1 omdöme)
0,0
0,0

Om kunden

Flagga för UNITED STATES
Royal Palm Beach, United States
5,0
1
Verifierad betalningsmetod
Medlem sedan apr. 17, 2019

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.