Find Jobs
Hire Freelancers

Create VBA script to copy-search-replace data between XLS and DOC

$30-250 USD

Terminado
Publicado hace alrededor de 8 años

$30-250 USD

Pagado a la entrega
We use Office 2013. We have 1 .xlsx file and several .dot files. We need a script (VBA) to copy some data in .xlsx, search tags in .docx and replace these tags by the data from .xlsx. Please, CHECK THE FILES ATTACHED. In the .xlsx file, currently when we fill the "Date" column on a new line, the "ID" column is automatically incremented. When we fill the "Date", we want another automatic creation of 2 buttons on each new line. On each line, we switch different options. Then, we click "Button 1" on the same line. Based on these options, the script will: • Open a new .docx from one of the .dot ([login to view URL]) • Copy specific cells from the .xlsx • Find tags in the .docx, like [[[TAG1]]] • Replace each tag by the corresponding .xlsx cell content. • Save the .docx (in PDF would be better) on a specific drive/path (the drive/path must be set up in advance, so the save is automatic without any action or selection from user side). (file name = column "Lot" from .xlsx). And again for a second button ("Button 2") and a second Word file ([login to view URL]). We also need minor VBA functions: - If column "Result" = ("" or "Not finished"), then Button 1 and Button 2 must be deactivated (unclickable). - if column "Phase 1" or "Phase 2"…. or "Phase 5" = ("" or "KO"), then Button 2 must be deactivated (unclickable). - If column "Type" = "Type 1", then use the .dot file "[login to view URL]" when clicking Button 1. If column "Type" = "Type 2", then use the .dot file "[login to view URL]" when clicking Button 1. ...... If column "Type" = "Type 7", then use the .dot file "[login to view URL]" when clicking Button 1. The design of the .dot files is not done yet. I put only the tags inside, but I need to remain free to do whatever I want on these documents and place the tags anywhere I want with any format (font, size etc.), and the replacement must keep the format. It must work with any font on my system, including special latin caracters. WE NEED THIS VERY FAST !!! DELIVERY MAX: NEXT MONDAY (better next saturday).
ID del proyecto: 9760753

Información sobre el proyecto

12 propuestas
Proyecto remoto
Activo hace 8 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 m serious freelancer with 100% completion rate and i've done hundreds of macros like this one. If you are interested, pm me. I can create you a demo probably even today, and finish everything by tomorrow. As i said i m serious freelancer and i've never took a single dollar unless my solution was perfect. Thanks, Milan
$77 USD en 1 día
5,0 (422 comentarios)
6,8
6,8
12 freelancers están ofertando un promedio de $106 USD por este trabajo
Avatar del usuario
Hi, I am good at Vba script in excel and word. Looking forward to work on this project. I would like to discuss the project in detail.
$250 USD en 4 días
5,0 (798 comentarios)
7,9
7,9
Avatar del usuario
Hi: I have a few questions: Which columns in xlsx denote the ta that will be replaced? Button 1 will work for dot files Doc-1-A to Doc-1-G while Button for Doc-2 dot file? Just to highlight that as we are adding 2 button for every row, the size of the file will become very large if you keep on adding rows. This can slow down the Excel file at a later date. Please note that over 90% of my completed projects are related to Excel and VBA. Moreover, i have 100% completion rate and 5-star feedback on projects. Please message me to discuss more.
$111 USD en 3 días
4,9 (157 comentarios)
6,9
6,9
Avatar del usuario
I can do it for you quickly and exactly .
$150 USD en 3 días
4,9 (105 comentarios)
6,6
6,6
Avatar del usuario
Hi there My name is Redouane I am very interested in your project. Kindly start messaging so we can discuss further details. Thank you
$70 USD en 2 días
4,9 (134 comentarios)
6,3
6,3
Avatar del usuario
Hello, I am interested in this project. I am proficient with Excel and VBA and macros and I think i could help you with this task. Please contact me for more information.
$172 USD en 3 días
4,9 (130 comentarios)
5,8
5,8
Avatar del usuario
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 65 projects, almost 55+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VBA/VB/.NET, SQL, MS Office, Access/Excel/Word, Database, 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. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$105 USD en 3 días
4,8 (72 comentarios)
5,8
5,8
Avatar del usuario
Hi! I have made a lot of excel models (including macros) for my clients. Please see my portfolio, you will find P&L file with macros which accumulate a lot of info from different file - it's about my qualification. Everything should be done till 29.02.2016? I will need you for consulting on holydays. I'm well experienced in excel/spreadsheets/business plans PS Excel/VBA/Macros expert, Engineer & MBA degree.
$50 USD en 4 días
4,9 (8 comentarios)
1,8
1,8
Avatar del usuario
Hello Sir, My name is Chathura Sadeepa and I am expert in Data Entry and Writing field. I would love to have the opportunity to discuss your project with you. I feel that I am a suitable match for the job. I have 1year of experience in Data Entry, Microsoft Word and Microsoft Excel. Excellent English Language, analytical and Data Entry skills. I am ready to work anytime and I have as fast typing speed. If you feel there is a mutual interest, I would welcome the opportunity to meet with you to learn more about your company, the requirements of the position, and how my qualification would be a good fit. Please let me know a time that works best for you and I will make sure that I make myself available. Thank you for your time and Consideration. With Regards, Chathura Sadeepa.
$45 USD en 2 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de FRANCE
Paris, France
5,0
38
Forma de pago verificada
Miembro desde jun 13, 2011

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.