Excel 11.0 Library

[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 that changed in the 11.0
libray 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

 

[Cindy M -WordMVP-]

Hi Al,

What is ImgEdit1? Is this an ActiveX control you've obtained,
somewhere?

Looking up the error message you report in the Knowledge Base
doesn't bring up any Office 2003-specific articles, but the
few it does turn up are related to ActiveX controls. A couple
said the projects need to be opened and recompiled; you might
try that.

Another refers to document corruption in Word.

There's also the fact that security has been increased in
Office 2003, and older controls will not have been digitally
signed. You might try deleting the control currently in the
workbook and inserting it again from the Control Toolbox
(assuming this is where it came from, originally).

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 that changed in the 11.0
libray 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

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun
8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail