Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 07-05-2010, 10:41 PM
velohead velohead is offline General VBA Question Windows XP General VBA Question Office 2003
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....

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

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 - Senior Forums

All times are GMT -7. The time now is 06:41 AM.

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