Update excel object in Word

Wrox Programmer Forums

		Wrox Programmer Forums > Microsoft Office > Other Office > Word VBA
Update excel object in Word

Word VBA Discuss using VBA to program Word.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Word VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

May 23rd, 2010, 10:17 PM

slamdunk

slamdunk is offline

Registered User

Join Date: May 2010

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Update excel object in Word

Hi,

I've a word document with excel object. The cell b1 is set to import data from a text file. How can I get this cell to import data automatically when the word document opens without any user interaction?

Thanks!

Old

May 26th, 2010, 11:34 PM

Shasur

Shasur is offline

Friend of Wrox

Join Date: Sep 2005

Posts: 812

Thanks: 1

Thanked 53 Times in 49 Posts

Default

Hi

Check if Document_Open event will help you (http://msdn.microsoft.com/en-us/libr...ice.10%29.aspx)

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help!! Problem instantiating WORD object using C#.	handymulia	ASP.NET 1.0 and 1.1 Basics	3	November 16th, 2006 05:18 PM
Help!! Problem instantiating WORD object using C#.	handymulia	ASP.NET 1.0 and 1.1 Professional	1	June 2nd, 2005 12:55 AM
WORD COM object in ASP	mcinar	Classic ASP Basics	0	April 14th, 2005 10:34 AM
Accessing WORD object in ASP	mcinar	Classic ASP Basics	5	March 30th, 2005 04:19 PM