Visual Basic

[EEA]

We recently upgraded to Office 2003 from Office 2000. In excel we copied data
to word then to powerpoint with the following code:

Range("A12", "P57").Select
Selection.Copy

Word.ActiveWindow.Selection.PasteSpecial
DataType:=wdPasteEnhancedMetafile
Word.ActiveWindow.Selection.Copy

Now that we are using Office 2003, I get an error message on the last line
which copies from word to paste later into power point. The error message is
4605 - method or property not available because no text is selected. I can
add a statement to select the text that was pasted, but this wasn't needed
before. Is this code change necessary or is there an option somewhere that
can be set?

 

[Bob Buckland ?:-\)]

Hi EEA,

You may want to post this in the Powerpoint newsgroup,
one of the Word VBA newsgroups or in Officedev
(links below)

=======
We recently upgraded to Office 2003 from Office 2000. In excel we copied data
to word then to powerpoint with the following code:

Range("A12", "P57").Select
Selection.Copy

Word.ActiveWindow.Selection.PasteSpecial
DataType:=wdPasteEnhancedMetafile
Word.ActiveWindow.Selection.Copy

Now that we are using Office 2003, I get an error message on the last line
which copies from word to paste later into power point. The error message is
4605 - method or property not available because no text is selected. I can
add a statement to select the text that was pasted, but this wasn't needed
before. Is this code change necessary or is there an option somewhere that
can be set? >>
--
LLet us know if this has helped you,

Bob Buckland ?
MS Office System Products MVP
*courtesy is not expensive and can pay big dividends8

A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.word.vba.general
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.word.vba.general

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com