Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-21-2016, 10:06 AM
balaji balaji is offline Macro to replace Image, Numbers in Table and in multiple protected word document Windows 10 Macro to replace Image, Numbers in Table and in multiple protected word document Office 2013
Novice
Macro to replace Image, Numbers in Table and in multiple protected word document
 
Join Date: Mar 2016
Posts: 7
balaji is on a distinguished road
Default Macro to replace Image, Numbers in Table and in multiple protected word document

I am struggling at this, I have received 200 word documents for which I need to make set changes on all, Below are th changes requested -



NOTE : All Word Documents are password protected, and after the changed are made need to be saved as current month -

1 - Logo to be replaced.
2- In a already existing table need to replace numbers,
3 - In the given table need to insert a row and add comments to the row.
4- Update Header and footer with present Month & Year.

Please help.
Reply With Quote
  #2  
Old 03-21-2016, 10:11 PM
gmayor's Avatar
gmayor gmayor is offline Macro to replace Image, Numbers in Table and in multiple protected word document Windows 10 Macro to replace Image, Numbers in Table and in multiple protected word document Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Is the password the same for all the documents? And what does "be saved as current month" mean?
1. Where and how is the logo inserted?
2. Replace which numbers with what?
3. Insert a row where and in which cell add the comments?
4. What is in the headers and footers that needs to be 'updated'

Your requirements are so vague as to be impossible to make suggestions. You could start with http://www.gmayor.com/document_batch_processes.htmwhich will handle the files, and can be used with a custom process that can be configured to do what you require (provided the passwords are all the same - if not you will have to process them individually).

If you need help with the processes a good place to start would be to provide a sample document. You can change any sensitive information for non-sensitive information that doesn't affect the layout of the document.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 03-22-2016, 01:25 AM
balaji balaji is offline Macro to replace Image, Numbers in Table and in multiple protected word document Windows 10 Macro to replace Image, Numbers in Table and in multiple protected word document Office 2013
Novice
Macro to replace Image, Numbers in Table and in multiple protected word document
 
Join Date: Mar 2016
Posts: 7
balaji is on a distinguished road
Default

Apologies not being clear on my request, I have provided the details below, Hope this helps to understand my request better.


Is the password the same for all the documents? And what does "be saved as current month" mean?
"The password is same for all the documents", the old files are named as "xxxxxx-04/15", which needs to be changed to "xxxxxx-03/16"

1. Where and how is the logo inserted? - "there is a old company logo on the document needs to be replaced with the new logo".
2. Replace which numbers with what? - To be replaced with numbers again.
3. Insert a row where and in which cell add the comments? - "there are 3 tables with vendor name and fees and description, In one of the tables I need to add a new vendor details by adding a new row"
4. What is in the headers and footers that needs to be 'updated' - "Header and Footer has the version date as 04/2015, needs to be updated to 03/2016"
Reply With Quote
  #4  
Old 03-22-2016, 05:34 AM
gmayor's Avatar
gmayor gmayor is offline Macro to replace Image, Numbers in Table and in multiple protected word document Windows 10 Macro to replace Image, Numbers in Table and in multiple protected word document Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Sadly you haven't answered most of the questions I posed. Apart from the filenames, the header/footer dates and the common password, the rest remains a complete mystery.

1. You already said you wanted to replace a logo, but where EXACTLY is it located in the document and how was it inserted. Are there other images in the document, especially in the same area as the one you want to replace. What's the filename of the new logo and where is it stored.

2. Which numbers EXACTLY do you need to replace? What numbers are they to be replaced with?

3. Do we have to guess which table, where in the table you want the row added, and which cells of that row the mysterious new data is meant to go in?

You are going to have to meet us half way if you expect help on this. This type of exercise is rarely simple, and without a sample of the document almost impossible.

Without access to a document that is similar to the documents you wish to process, any suggested code is likely to do more damage than good to your hundreds of documents.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #5  
Old 03-22-2016, 05:53 AM
balaji balaji is offline Macro to replace Image, Numbers in Table and in multiple protected word document Windows 10 Macro to replace Image, Numbers in Table and in multiple protected word document Office 2013
Novice
Macro to replace Image, Numbers in Table and in multiple protected word document
 
Join Date: Mar 2016
Posts: 7
balaji is on a distinguished road
Default

Hi Gmayor,

I am really sorry for the incomplete information, Just that the ask is too much for me to explain, I will provide a sample document soon.

Regards,
Balaji
Reply With Quote
  #6  
Old 03-23-2016, 12:49 AM
macropod's Avatar
macropod macropod is offline Macro to replace Image, Numbers in Table and in multiple protected word document Windows 7 64bit Macro to replace Image, Numbers in Table and in multiple protected word document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Now Cross-posted at: http://www.mrexcel.com/forum/excel-q...-document.html
without the decency to acknowledge the work done here!

For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 03-23-2016, 01:29 AM
balaji balaji is offline Macro to replace Image, Numbers in Table and in multiple protected word document Windows 10 Macro to replace Image, Numbers in Table and in multiple protected word document Office 2013
Novice
Macro to replace Image, Numbers in Table and in multiple protected word document
 
Join Date: Mar 2016
Posts: 7
balaji is on a distinguished road
Default

Hi I have cross posted on other sites as I was not able to log in into this site, Sorry for the inconvenience caused.



Regards,
balaji
Reply With Quote
  #8  
Old 03-23-2016, 01:39 AM
macropod's Avatar
macropod macropod is offline Macro to replace Image, Numbers in Table and in multiple protected word document Windows 7 64bit Macro to replace Image, Numbers in Table and in multiple protected word document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

In that case, kindly provide the relevant cross-post links both here and on all the other sites affected.

PS: This site has had no log-on problems and, even if there had been such problems, that would not excuse your failure to follow the cross-posting etiquette/rules of any of the affected sites.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 03-23-2016, 02:51 AM
balaji balaji is offline Macro to replace Image, Numbers in Table and in multiple protected word document Windows 10 Macro to replace Image, Numbers in Table and in multiple protected word document Office 2013
Novice
Macro to replace Image, Numbers in Table and in multiple protected word document
 
Join Date: Mar 2016
Posts: 7
balaji is on a distinguished road
Default

Below are the cross post links -

Mrexcel - http://www.mrexcel.com/forum/excel-q...ml#post4468474

excelforums - http://www.excelforum.com/word-progr...-document.html

VBAexpress - http://www.vbaexpress.com/forum/show...ument&p=340258

Regards,
Balaji
Reply With Quote
  #10  
Old 03-23-2016, 11:35 AM
balaji balaji is offline Macro to replace Image, Numbers in Table and in multiple protected word document Windows 10 Macro to replace Image, Numbers in Table and in multiple protected word document Office 2013
Novice
Macro to replace Image, Numbers in Table and in multiple protected word document
 
Join Date: Mar 2016
Posts: 7
balaji is on a distinguished road
Default

Any Help on this one is appreciated.

Regards
Reply With Quote
  #11  
Old 03-24-2016, 02:11 AM
balaji balaji is offline Macro to replace Image, Numbers in Table and in multiple protected word document Windows 10 Macro to replace Image, Numbers in Table and in multiple protected word document Office 2013
Novice
Macro to replace Image, Numbers in Table and in multiple protected word document
 
Join Date: Mar 2016
Posts: 7
balaji is on a distinguished road
Default DELETING POST ( Cross Post)

Post deletd, As Corss Posted.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to replace Image, Numbers in Table and in multiple protected word document Replace footer image in multiple Word documents heyjim Drawing and Graphics 1 08-07-2015 05:23 PM
Macro to replace Image, Numbers in Table and in multiple protected word document Macro to Unprotect password protected document pooklet Word 2 12-08-2014 01:32 AM
Macro to replace Image, Numbers in Table and in multiple protected word document Word VBA Macro to Find and Replace based on the Alt Text of an Image bennymc Word VBA 1 01-27-2014 04:23 PM
Using macro to add variable number of rows to a protected word table Julia Word Tables 1 01-09-2013 06:04 AM
Macro to replace Image, Numbers in Table and in multiple protected word document Protected Document: Multiple Hyperlinks Andrew H Word VBA 7 11-26-2012 01:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:53 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft