Find Jobs
Hire Freelancers

Write an excel vba code

$30-250 USD

Terminado
Publicado hace alrededor de 5 años

$30-250 USD

Pagado a la entrega
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.
ID del proyecto: 19271824

Información sobre el proyecto

19 propuestas
Proyecto remoto
Activo hace 5 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 1 día
4,9 (75 comentarios)
6,5
6,5
19 freelancers están ofertando un promedio de $142 USD por este trabajo
Avatar del usuario
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 en 3 días
4,9 (445 comentarios)
8,2
8,2
Avatar del usuario
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 en 3 días
4,8 (161 comentarios)
7,1
7,1
Avatar del usuario
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 en 3 días
4,9 (62 comentarios)
6,6
6,6
Avatar del usuario
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 en 5 días
5,0 (43 comentarios)
6,1
6,1
Avatar del usuario
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 en 3 días
4,9 (43 comentarios)
5,7
5,7
Avatar del usuario
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 en 5 días
4,9 (18 comentarios)
5,1
5,1
Avatar del usuario
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 en 3 días
5,0 (31 comentarios)
4,8
4,8
Avatar del usuario
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 en 5 días
5,0 (7 comentarios)
3,5
3,5
Avatar del usuario
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 en 1 día
5,0 (2 comentarios)
3,0
3,0
Avatar del usuario
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 en 2 días
5,0 (1 comentario)
2,2
2,2
Avatar del usuario
I have 20 years in Database Developing, Programming, Training, and Accounting Solutions / Finance with Computer
$155 USD en 3 días
5,0 (2 comentarios)
1,5
1,5
Avatar del usuario
New career Relevant Skills and Experience 2 years worked on a company
$111 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (1 comentario)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Royal Palm Beach, United States
5,0
1
Forma de pago verificada
Miembro desde abr 17, 2019

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.