Excel 11.0 Object Library
 

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

Excel 11.0 Object Library
 

Hi
have you checked 'Tools - References' in the VBE Editor?

--
Regards
Frank Kabel
Frankfurt, Germany

"Al" schrieb im Newsbeitrag
...
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

Excel 11.0 Object Library
 

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


-----Original Message-----
Hi
have you checked 'Tools - References' in the VBE Editor?

--
Regards
Frank Kabel
Frankfurt, Germany

"Al" schrieb im
Newsbeitrag
...
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

.