A procedure working for years with XP and Windows 7 now fails with Windows 10, giving the message - "Error 2725: Description: The OLE server isn't registered."
I have a database (Access 2007) which links to an Excel workbook that is running invisibly all the time in the background. The Excel sheet performs some very complicated calculations.
In the database I have a form with a control which is an Unbound Object Frame called 'oleXLData'
Using the VBA code as follows, it visits a designated worksheet, selects the range of a block of cells (denoted in 'B1' as shown below), and copies the displayed data and pastes the picture into the Unbound Object Frame.
me.oleXLData.SetFocus
wsSheet.Range(wsSheet.Range("B1")).CopyPicture
me.oleXLData.Action = acOLEPaste
This now fails with Error 2725
Any help please on how to rectify this problem would be very appreciated. Cheers Alan
I have a database (Access 2007) which links to an Excel workbook that is running invisibly all the time in the background. The Excel sheet performs some very complicated calculations.
In the database I have a form with a control which is an Unbound Object Frame called 'oleXLData'
Using the VBA code as follows, it visits a designated worksheet, selects the range of a block of cells (denoted in 'B1' as shown below), and copies the displayed data and pastes the picture into the Unbound Object Frame.
me.oleXLData.SetFocus
wsSheet.Range(wsSheet.Range("B1")).CopyPicture
me.oleXLData.Action = acOLEPaste
This now fails with Error 2725
Any help please on how to rectify this problem would be very appreciated. Cheers Alan