Completato

Word Updating From Excel VBA

As you will know the footers, headers and fields in Word do not automatically update so I currently have a Word based VBA macro which does this for single file the when the code runs – it also applies a standard font to all the text. Then it saves the file and closes it.

All I require to do is automate this by replicate this code within VBA Excel for all Word files in a selectable folder. Typically 100 Word files.

The process will be, the code:-

1. runs the new Excel based VBA code from a command button

2. selects the source folder with the word files in it (Picked manually by the user)

3. writes the file list in the chosen folder to the Excel tab with the command button on it (clears any old text first)

4. opens the first word file and updates all the footers, headers and quick fields

5. updates the font in the word files to Calibri

6. saves the open word file and closes it

7. selects the next file in the list and the process repeats until all the word files are updated

8. the modified files should overwrite the existing files in the source folder

9. the macro ends

I have to use Excel as I have another set of vba code with does multiple word file updating quite well using find and replace

Competenze: Excel, Excel VBA, Word

Vedere di più: converteren word tabel naar excel, can copy word document paste excel document, vba word macro refrence excel range, auto populate word document from excel, word vba update fields in header, vba update word, macro to update all links, excel vba edit word document, word vba update links, vba word update specific field, word vba update all fields, convert word doc columns excel, convert word document table excel, start macro word drop box excel, word document table excel sheet, convert word doc table excel doc, convert word table rows excel, convert word document rows excel columns, free online typing word power pointand excel, visual basic word schrijf naar excel file

Sul datore di lavoro:
( 0 valutazioni ) Birkenhead, United Kingdom

ID Progetto: #17836772

Assegnato a:

kolosibalint

Hi, I have created a large number of similar Excel tools that makes changes in Word files. All of the requirements are clear I will only need a few sample Word files and I need to if there are any rules based on wh Più

$50 USD in 1 giorno
(99 valutazioni)
6.5

15 freelance hanno fatto un'offerta media di $31 per questo lavoro

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Più

$50 USD in 1 giorno
(620 Recensioni)
8.3
TonmoyRoy111

Dear client I have read the specifications. I can automate the whole process. Please consider my bid and provide me the opportunity to do this project for you. Roy

$40 USD in 1 giorno
(260 Recensioni)
6.5
aubrey03

I am a VBA expert and I have done a similar project before so I am confident that I am the best freelancer for this project. You may check some of my projects here: [login to view URL] Più

$25 USD in 1 giorno
(44 Recensioni)
5.1
sloker18

I am proficient with excel macro/VBA development, I can write the macro to repeat word modification for all files selected as specified, if you are interested feel free to message me, I am available to start your proje Più

$30 USD in 1 giorno
(39 Recensioni)
4.7
RushService

Feel fee to contact me for Word Updating From Excel [login to view URL] me message to discuss further more details .We provide the commments,images,videos,demos and live sessions in order to help the [login to view URL] payment onl Più

$30 USD in 1 giorno
(5 Recensioni)
4.0
NoelReubenMuturi

Hello, I am Noel, an expert in excel with a keen attention to detail. I endeavor to offer a personalized product, meet the client’s specifications, and produce quality work; I would love to speak with you further abou Più

$25 USD in 1 giorno
(10 Recensioni)
4.2
neeleshthakur333

Hi Good day! A serious freelancer here! I have a lots of available time to this work. I can help you to complete this work, but need to know the full requirements to assess how long would it take to complete this Più

$15 USD in 1 giorno
(0 Recensioni)
0.0
prakashaero007

There are no secrets to success. It is the result of preparation, hard work, and learning from failure.

$15 USD in 1 giorno
(0 Recensioni)
0.0
harisali49

I am a graduate of Cambridge international college Australia. Having a degree in major Financial Accounting, with different certification which includes Certified Management Accountant, foundations diploma of Accounti Più

$100 USD in 2 giorni
(0 Recensioni)
0.0
$25 USD in 1 giorno
(0 Recensioni)
0.0
amit9643383719

give me the full detail of wark and also give example what type of work you want so plzzz contact me and give me full details of work

$25 USD in 1 giorno
(0 Recensioni)
0.0
rommelferrolino

Hello, I'm Rommel - I'm a freelancer for your excel needs. I have been working as a Quality control and assurance analyst for the past 20 years and have been using excel as a tool in analyzing graphs, formulas, and Più

$15 USD in 1 giorno
(0 Recensioni)
0.0
vakash628444

i am vba developer in american express. I am expert in vba/macro, advance excel, ms access and sql. I have more than 6 years of experience. I am doing this kind of work for many years that's why you can aspect quality Più

$15 USD in 1 giorno
(0 Recensioni)
0.0
Slavik159

Hello! I will glad to work with You. I do not have much reviews, so I work for food)) I have a lot experiences in excel (pivot table, excel formulas, vba macros). I previously did a similar macro.

$10 USD in 1 giorno
(1 Recensione)
0.0