Excel 11.0 Object Library

A

Al

I had a macro that worked great until this morning. This
morning Office 2003 (Windows 2000) was installed on my
machine. Previously I had Office 2000 (Windows 2000) with
the Excel 9.0 Object Library. No problems, life was good!

Now I get the following error: Can't exit design mode
because Control "ImgEdit1" can not be created.

Nothing has changed with the macro. The same file was
opened yesterday and today with painfully different
results. Is there something in the 11.0 library that has
changed from the 9.0 library?

Here is the code when the workbook opens:

Private Sub Workbook_Open()

Pic = "L:\North America\6699\wrappedcarnew1.tif"

Worksheets(1).ImgEdit1.Image = Pic
Worksheets(1).ImgEdit1.FitTo 0
Worksheets(1).ImgEdit1.Display
Range("L1").Select

*** Rest of code

End Sub

Any help or suggestions on how to correct or code the
macro so I don't get this error would be greatly
appreciated. Thanks for the help.....Al
 
A

Al

Yes.......all of the references are the same except that
the Object Libraries are now 11.0 instead of 9.0.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top