Find Jobs
Hire Freelancers

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

$30-250 USD

Ukończony
Opublikowano około 8 lat temu

$30-250 USD

Płatne przy odbiorze
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).
Identyfikator projektu: 9760753

Informację o projekcie

12 ofert
Zdalny projekt
Aktywny 8 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
Przyznano:
Awatar Użytkownika
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 w 1 dzień
5,0 (422 opinii)
6,8
6,8
12 freelancerzy składają oferty o średniej wysokości $106 USD dla tej pracy
Awatar Użytkownika
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 w 4 dni
5,0 (798 opinii)
7,9
7,9
Awatar Użytkownika
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 w 3 dni
4,9 (157 opinii)
6,9
6,9
Awatar Użytkownika
I can do it for you quickly and exactly .
$150 USD w 3 dni
4,9 (105 opinii)
6,6
6,6
Awatar Użytkownika
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 w 2 dni
4,9 (134 opinii)
6,3
6,3
Awatar Użytkownika
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 w 3 dni
4,9 (130 opinii)
5,8
5,8
Awatar Użytkownika
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 w 3 dni
4,8 (72 opinii)
5,8
5,8
Awatar Użytkownika
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 w 4 dni
4,9 (8 opinii)
1,8
1,8
Awatar Użytkownika
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 w 2 dni
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga FRANCE
Paris, France
5,0
38
Zweryfikowana metoda płatności
Członek od cze 13, 2011

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.