Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word VBA

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 07-16-2012, 04:15 AM
krishnaoptif krishnaoptif is offline Windows XP Office 2007
Novice
 
Join Date: May 2012
Posts: 23
krishnaoptif is on a distinguished road
Default Please Help for VBA Code for Attached File..

Respected Experts,



Please find attached Excel file and MS word file...

I have data in two columns A and B in MS excel file that will be search in attached MS word document and will be replace with color as per logic which i have written in ms word file..

I have also written some VBA code in ms word file in Module1 and module2 but that not works.... I am new in vba...

so Please look at this and create a new module with VBA code for the same and
Please attached updated word file with vba code in this forum or send it to me at krishnaoptif@gmail.com...

This is really urgent..I am waiting for your reply Pleaseeeeeeeeeee..

Last edited by krishnaoptif; 07-16-2012 at 04:18 AM. Reason: for some change
Reply With Quote
  #2  
Old 07-16-2012, 11:37 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,352
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

It seems to me that I have already supplied you with the code you require. See:
http://www.msofficeforums.com/word-v...ipt-excel.html

Also, there is not much point in you telling us you need urgent help. So far, every time you have sought help you have said it is urgent. If you need help you shouldn't wait till it's urgent.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 07-16-2012, 11:49 PM
krishnaoptif krishnaoptif is offline Windows XP Office 2007
Novice
 
Join Date: May 2012
Posts: 23
krishnaoptif is on a distinguished road
Default

Hi Mr Macropod,

but this link code does not works for my this new diffrent logic....
i am not able to setup you code with my logic..

May you see my attached file and apply your codding in this as per logic which are written in my ms word file.... and please send me your codding with attached ms word file... so that will help me a lot...

when you will run in ms word your code then you will get a actuall problm....
Reply With Quote
  #4  
Old 07-17-2012, 12:29 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,352
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Your sample before/after paragraphs are quite inconsistent in their use of full words and acronyms. It is nonsense to think a macro can replicate such inconsistency.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook2003 - how to write attached file to folder nodari Outlook 1 05-26-2011 08:51 AM
Impossible to open or save attached file Lafayette Outlook 2 04-29-2011 04:41 PM
Problem: Open attached Word file markg2 Outlook 0 02-09-2011 09:18 AM
Hyperlink to attached file in email message spino Outlook 0 08-05-2010 05:56 AM
Outlook xp slow when Browsing to attached a file jmelgar1 Outlook 0 09-23-2008 01:49 PM


All times are GMT -7. The time now is 03:02 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft