Results 1 to 2 of 2

Thread: Add VBA Reference From Another Application Excel To PowerPoint

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Jun 2013
    Posts
    1
    Rep Power
    0

    Add VBA Reference From Another Application Excel To PowerPoint

    I have no problem setting up references from one workbook to another. calling workbook references my class variables in called workbook. I want to do the same thing from a powerpoint file (ie reference my class variables from the called workbook). The class variables are not the excel objects but classes that i have defined for my own application. Is this possible? I tried using the tools>references function in VBE that i used for the workbook to workbook references in powerpoint but the excel workbook does not show up in the references list from powerpoint. Any help would be greatly appreciated.

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    ds1001, I am not sure about 2013, but up till 2010, you cannot add the reference of one application file to the VBA project of another application file, for example you cannot add a macro enabled excel file or even an add-in excel file on to the VBA project of a PowerPoint presentation.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Copy/Paste Excel Range/Chart into Powerpoint VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 1
    Last Post: 03-13-2014, 02:59 PM
  2. Did You Know:: 3D Reference in Excel
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 06-02-2013, 01:28 PM
  3. Replies: 1
    Last Post: 02-14-2013, 11:08 AM
  4. Excel Application.OnKey With Parameter
    By Excel Fox in forum Excel Help
    Replies: 0
    Last Post: 11-29-2011, 01:31 PM
  5. Add ribbon programmatically to Excel 2010 using VBA
    By heapifyman in forum Excel Ribbon and Add-Ins
    Replies: 6
    Last Post: 07-18-2011, 09:16 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •