index > Visual Studio Tools for Office > Help embedding Excel documents into a Word Document

Help embedding Excel documents into a Word Document

Hi there

Can someone tell me how to or direct me to an appropriate tutorial that can show me how I can, programmatically, insert an excel 2003 sheet into a word 2003 document by using the VSTO

EG:

Document a = WordDocument

Document b = ExcelSheet

a.Section(n).Insert(b, DisplayAsIcon)

I have hunted for advice on this but cannot find it anywhere. I am using VS.NET 2005 and am not fussed on a C# or VB.NET solution I just need to be able to insert the document.

Thanks!

Hatchman

I saw a question like this in the word.vba.general newsgroup last week. Was that your's? Are you all set, now?

-- Cindy Meister (Word MVP)

Cindy Meister

Hi Cindy

I'm afraid I haven't heard anything back at all

Do you know of a way that in which this can be done?

Regards

Andrew

Hatchman

Hi Andrew

Since you want to display as an icon, are you wanting to bring in (and link?) an existing sheet, then?

The best way to get started on something like this is to record your actions in a macro. That will give you the basic syntax. An embedded Excel sheet is an OLE object, BTW; Word treats these like graphical objects.

If you need more help beyond the actual insertion the macro recorder gives you, please post in the office.developer.automation newsgroup. Copy the code the macro recorder gave you (or the code you've adapted from the recorder) and describe exactly where you're having problems.

-- Cindy Meister (Word MVP)

Cindy Meister

Thanks again Cindy.

Unfortunately I didn't want to go down the VBA Macro route, I was hoping something in VSTO would allow me to do it instead.

Hatchman

There's nothing special built into VSTO for inserting or working with embedded OLE objects; automation of the COM object model is the only possibility. You use the VBA route to get the basic object model SYNTAX. Our goal in this forum is to show you how to work with the tools, and one of the tools at your disposal is the macro recorder.

-- Cindy Meister (Word MVP)

Cindy Meister

reply 6