Cannot create object error in Excel 2003
I'm getting the error: "Cannot create object" when instantiating a form
commandbutton in Excel 2003 with VBA code. The code works fine in XL2007. I
suppose also woth noting is that the XL07 is running under Vista while XL03
is running under WinXP Pro with the latest SP.
The command that fails is as follows:
wksPhotos.OLEObjects.Add ClassType:="Forms.CommandButton.1"
wlsPhotos is the active worksheet and the statement above is contained
within it.
I've moved the code to module with no change in results.
Any ideas?
--
Jack
<<
|