View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jack Jack is offline
external usenet poster
 
Posts: 10
Default 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
<<