+ Reply to Thread
Results 1 to 2 of 2

Macro to access embedded excel object

  1. #1
    Registered User
    Join Date
    03-15-2010
    Location
    CT
    MS-Off Ver
    Excel 2010
    Posts
    72

    Macro to access embedded excel object

    Hello Excel/PowerPoint folks,

    I am running PowerPoint 2010 and while I'm ok with general usage, I'm not as familiar with the inner workings as I am with Excel. From what I've Googled, there is no longer a Record Macro option in PP 2010 so my main method of learning is not available in PowerPoint.

    In my current presentation, I have multiple slides with embedded Excel spreadsheets (Insert -> Table -> Excel Spreadsheet). Multiple people will be updating each slide and there's no guarantee they'll refocus the cells to "A1" to ensue the correct information is displayed when the presentation runs.

    What I want to do is create a macro that will go through each slide and set the focus of each embedded excel sheet to cell "A1" to ensure when the presentation runs the information I want displayed is in frame.

    Can anyone provide any assistance or direction in this (I'm assuming/hoping) simple Macro?

    r/

    SUPPO

  2. #2
    Registered User
    Join Date
    03-15-2010
    Location
    CT
    MS-Off Ver
    Excel 2010
    Posts
    72

    Re: Macro to access embedded excel object

    So I have the below code that will find the embedded excel object and will change the value of the cell indicated in .Range:

    Please Login or Register  to view this content.
    I'm still having issues if I have cell AB400 displayed, I can't get it to move the screen display to cell A1. I've tried .Select, .SetFocus .Show and a few others but either nothing happens or I get an error.

    for .Select I get the error: "Run-Time Error '1004' Select method of Range failed"

    any suggestions are appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to open a specific page of an embedded object (pdf) by running a macro in VBA
    By mchsueh87 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-26-2016, 05:43 AM
  2. [SOLVED] Macro to add an embedded object and resize to certain dimensions
    By Eamster in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-04-2013, 12:41 PM
  3. Help with VBA Excel Range to Embedded Word Object
    By cuchulainem in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-28-2013, 04:53 PM
  4. Embedded PDF Object positioning using Macro
    By timepass111 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-21-2011, 03:24 PM
  5. set calculation property in embedded excel object
    By erickd in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-17-2010, 03:55 PM
  6. Embedded Excel Object - Containers Path and Name
    By GerryO in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-21-2006, 10:40 AM
  7. Replies: 0
    Last Post: 07-21-2006, 09:45 AM
  8. How to load/insert/update an embedded word object to Access...
    By MJ in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-21-2006, 07:55 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1