R
Richard Smith
Greetings.
I have a curious problem that so far is only happening under certain logins
when running Excel VBA on my Windows 2003 server. The error is shown above
in the subject line.
It is occurring on a line of code that simply says:
Range("B6").Font.Bold = True
If I break the code at this line and then step through it, it steps through
fine. If I then "continue", it breaks further down the road.
If I let the code fail and then enter into Debug mode and I then alt-tab
back to the activeworkbook, the activeworkbook is frozen. I can't even
select any new cells. If I then stop the code execution, I can't even see
any of the Excel worksheets any longer. I can alt-tab to them but my screen
never refreshes to the worksheet. I just keep seeing the VBA Editor.
This VBA code is interacting with an Access database using the ActiveX Data
Objects 2.8 Library reference.
I'm very suspicious that some failure is arising in the db or in the link
between the db and xl and that this is locking up the worksheet. Then the
routine call to set the bold the font in cell B6 fails because the system is
locked up. What's curious to me, however, is why it fails here. There are
other formatting related commands right before this font.bold command that
don't have anything to do with the database.
Please help?
Many thanks,
Richard.
I have a curious problem that so far is only happening under certain logins
when running Excel VBA on my Windows 2003 server. The error is shown above
in the subject line.
It is occurring on a line of code that simply says:
Range("B6").Font.Bold = True
If I break the code at this line and then step through it, it steps through
fine. If I then "continue", it breaks further down the road.
If I let the code fail and then enter into Debug mode and I then alt-tab
back to the activeworkbook, the activeworkbook is frozen. I can't even
select any new cells. If I then stop the code execution, I can't even see
any of the Excel worksheets any longer. I can alt-tab to them but my screen
never refreshes to the worksheet. I just keep seeing the VBA Editor.
This VBA code is interacting with an Access database using the ActiveX Data
Objects 2.8 Library reference.
I'm very suspicious that some failure is arising in the db or in the link
between the db and xl and that this is locking up the worksheet. Then the
routine call to set the bold the font in cell B6 fails because the system is
locked up. What's curious to me, however, is why it fails here. There are
other formatting related commands right before this font.bold command that
don't have anything to do with the database.
Please help?
Many thanks,
Richard.