+ Reply to Thread
Results 1 to 3 of 3

Office 2010: Unable to embedded an .xls file that contains VBA code in a .ppt file

  1. #1
    Registered User
    Join Date
    03-13-2010
    Location
    Chapel Hill, NC
    MS-Off Ver
    Excel 2003
    Posts
    9

    Office 2010: Unable to embedded an .xls file that contains VBA code in a .ppt file

    I am trying to embed Excel .xls file objects that contain VBA code in pages of a .ppt file. Using the menus insert -> object -> from file.

    This works fine if I use Powerpoint 2003, but when I try to use Powerpoint 2010 I can get the object inserted but when I try to edit it, I get the following errors:

    First in Excel:
    Error accessing file. Network connection may have been lost.

    Then in PowerPoint:
    Microsoft PowerPoint can't start the application required to open this object. An error occurred and this featue is no longer functioning properly. Would you like to repair this feature now? I click "no" as I know the function is fine.

    then another PowerPoint error:
    There isn't enough memory available to read Worksheet.

    The files are stored on same disk drive.

    My troubleshooting so far:
    1. I have set all macro security for both Excel and Powerpoint 2003 and 2010 to none.
    2. I have checked any boxes that state trust VBA objects.
    3. If I insert the .xls object using PowerPoint 2003 on another system and then re-open the ppt file using 2010, I can then edit the .xls object.
    4. If I convert the .xls file to .xlsm, then insert, it will work fine.
    5. PowerPoint 2010 can insert and edit .xls objects that do not contain VBA code.
    6. I set the references in the Powerpoint VB editor to include Excel object library, no change.
    7. I have installed 2003 on the same system as 2010 (Win 7), and it will not work then, even in the 2003 applications.
    8. I have installed 2010 on the Win XP system and it did not work there either.
    9. I tried dragging and dropping the xls file onto the ppt page, that results in 7 of the 'Error accessing file. . ' messages before it inserts the object.
    10. If I insert the object in 2010, then try to edit the object on the 2003 system, I get the same edit errors.
    11. I can create a new Excel 97-2003 worksheet object, then add a macro to it after it is inserted and it will edit fine. It only errors when inserting from file.
    To reproduce the problem, open/create a powerpoint file (can be ppt or pptx). Then insert any xls file that contains some VBA code. Insert the file as an Excel 97-2003 worksheet object. After the object is inserted, select to edit the worksheet object. That is when the errors will occur.

    Windows 7 system details:
    OS - Windows 7 64-bit
    Office ver - 2010 Professional Plus
    Intel core2duo cpu
    4GB ram

    Windows XP system details:
    OS - Windows XP Pro SP3
    Office ver - 3002 Standard Edition SP3
    Virtual machine on Oracle VM VirtualBox

    Any help is greatly appreciated.

    Erick

  2. #2
    Registered User
    Join Date
    03-13-2010
    Location
    Chapel Hill, NC
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Office 2010: Unable to embedded an .xls file that contains VBA code in a .ppt fil

    No takes huh, could someone at least confirm that they can reproduce the problem? Or is this too much of a powerpoint problem?

  3. #3
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Office 2010: Unable to embedded an .xls file that contains VBA code in a .ppt fil

    probably coz not many have 2010!
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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