LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default Setting references in VBA

I am trying to write code in Excel to control Powerpoint. I located some
information that said to enable Excel to interact with other applications a
reference has to be set to the other application's object library. The info
said this could be done "in the Visual Basic Editor (VBE), select
References... from the Tools menu".

However, my "references" is greyed out so that I can't select it.

1) Not sure why?
2) Is this the only way I can get Excel to Control Powerpoint?

All I'm trying to do is a simple copy paste between applications, problem is
there's a lot of back and forth and I can't execute the Powerpoint code
automatically (from what I've read online so far), so I think controlling
from Excel is my best option.

Thanks for any insight.

Nicki



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How remove invalid references in ToolsReferences drop down box? [email protected] Excel Programming 1 July 7th 09 09:52 AM
Help with converting a block of cells with Absolute and mixed references to relative references Vulcan Excel Worksheet Functions 3 December 13th 07 11:43 PM
Setting Up References in the VBE NickHK Excel Programming 9 December 18th 06 04:22 AM
Setting References in VBA Todd Huttenstine[_3_] Excel Programming 2 April 25th 04 04:40 AM


All times are GMT +1. The time now is 11:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"