Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-05-2010, 10:41 PM
velohead velohead is offline General VBA Question Windows XP General VBA Question Office 2003
Novice
General VBA Question
 
Join Date: Jul 2010
Location: QLD, AUS
Posts: 6
velohead is on a distinguished road
Question General VBA Question

If I write a macro in excel, can it pass variables to Word in the following context....



Excel
copy contents of cell A1 and B1 (eg "Joe" and "Bloggs") and allocate to Variable_X and Variable_Y
open a Specific Word document
In Word....
Find [first_name] Replace with Variable_X
Find [last_name] Replace with Variable_Y

so that...
[first_name] becomes Joe
[last_name] becomes Bloggs

I presume this would be possible, provided that it is one macro ????
Is that correct ????
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
General VBA Question License and Activation, General... Plus, can Office 2000 read/edit Office 2003 files? Orlandes Office 9 09-24-2009 07:13 PM
General VBA Question One to many and many to one question Girlie4 Excel 3 08-09-2009 08:02 PM
Error: general mail failure. Quit excel restart mail system MitchellDM Outlook 1 12-19-2008 02:05 AM
Categories question & replying with attachment question glitzymama Outlook 0 03-15-2006 09:32 AM
General Options grayed out kpadgett Outlook 0 12-01-2005 08:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:59 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