OCX Controls Used in VBA-Enabled Applications Cannot be Side-By-Side (SxS) Registered

ActiveX Controls used in Office applications with VBA must have at least their type library registered in the registry to work properly.  VBA does not support Side-By-Side (SxS) registration of controls and this may prevent a control registered only by SxS from working correctly in Office. See the following post for more details:OCX Controls Used…

1

OCX Controls Used in VBA-Enabled Applications Cannot be Side-By-Side (SxS) Registered

Summary ActiveX Controls used in core Office Applications (such as Word, Excel, PowerPoint, or Visio) are bound using ITypeInfo from an associated type library (*.tlb) and extender library (*.exd) when created or loaded inside a document or macro dialog form (VBA UserForm).  VBA enables programmability to controls added to the host using code that assumes…

1

ShellExecute fails when called from Internet Explorer Protected Mode

When calling ShellExecute to open an Office document from Internet Explorer, the call will fail with a “File not Found” error if Protected Mode is turned on. The problem occurs after installing Office 2007 Service Pack 1 on Windows Vista. For full details, see the following post: ShellExecute fails when called from Internet Explorer Protected…

1

ShellExecute fails when called from Internet Explorer Protected Mode

Summary When calling ShellExecute to open of Office document from Internet Explorer, the call will fail with a “File not Found” error if Protected Mode is turned on. The problem occurs after installing Office 2007 Service Pack 1 on Windows Vista. Cause Internet Explorer Protected mode is available when running Internet Explorer 7 on Windows…

1

OLE/ActiveX Objects Copied from Office in Remote TS Session are Unavailable on Local Client Via RDP Clipboard

When attempting to copy and paste OLE or OCX objects from Office applications running on a remote desktop to another application running on your local desktop, you may fail to get the data expected, or will find the data is unavailable from the Paste Special dialog.  For full details, see the following post:OLE/ActiveX Objects Copied…

1

Excel OLE Embedding Errors if you have Managed Add-In Sinking Application Events in Excel

Managed addins/components that sink events on the Application object may cause problems with OLE functionality in that instance of Excel, resulting in errors or possible crash of host application trying to edit Excel embedded objects.  Managed addins can avoid this problem with custom code. Users seeing this problem can avoid the problems using an Excel…

0

Excel OLE Embedding Errors if you have Managed Add-In Sinking Application Events in Excel

Summary If you build a managed component that loads into Excel’s process space, and the managed code uses the PIA (or a custom IA using event delegates)  to sink events on the Application object, that Excel instance may encounter problems when used for OLE embedding.  The problems include: Being unable to update object if it…

1

Excel 2007 does not return shape data using XLL xlfGetDocument command

XLL add-ins using the xlfGetDocument command to obtain shape data may fail in Excel 2007 because a known problem in that version. The bug is being investigated for a fix in a future Excel release. See the following post for more details: Excel 2007 does not return shape data using XLL xlfGetDocument command

1

Excel 2007 does not return shape data using XLL xlfGetDocument command

Summary Microsoft Excel XLL add-ins using the xlfGetDocument command with the command type 42 to return a matrix of shapes (objects, images, controls) on the active sheet may encounter problems in Excel 2007, because the command fails to return any such information to the add-in.   The caller receives no error, but gets back an empty XLOPER, as if…

1