microsoft.public.word.vba.general
back to index
Group: microsoft.public.word.vba.general
From: Jay Freedman
Date: Friday, February 22, 2008 12:56 PM
Subject: Re: Creating Excel Spreadsheet in Word with VBA
From: Jay Freedman
Date: Friday, February 22, 2008 12:56 PM
Subject: Re: Creating Excel Spreadsheet in Word with VBA
On Fri, 22 Feb 2008 10:13:24 -0800 (PST), melon
>Kind of a stupid question. Is it possible to create/embed an excel
>spreadsheet into a word document with VBA?
>
>I can just create a regular table and then copy and paste to Excel,
>but I want to know if there is any better option.
You can use VBA syntax like this:
Selection.InlineShapes.AddOLEObject FileName:="C:\SomeFolder\book1.xls"
There are lots of variations on this.
--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.
