appactivate

[kevin smith]

i have been wroting vba for 8 years and have not had any
problems with this until now.

our office has updated to windows xp and xp office.
from NT and office 2000/97

XP now hadles each visible excel workbook open within the
single application as a seperate toolbar object or groups
them using the workbooks window name.

Even though there is only one instance of the excel app
open, all my appactivate commands which attempt to give
the focus back to that window after sending the focus to
other apps for screen scraping etc now debug. i have
quite a few too. (8 years of programs)

Whats even more fustrating is that it only happens if
there is more than one workbook open as all run fine if
there is only a single book active.

is there any way to bypass this suposed XP enhancement.

only two optios i can think of and both are
programatically regressive not progressive!

1).do i have to call all my window captions "microsoft
ex ???"
or 2) have to rename all my appactivate commands to the
active workbook name not the application window name at
the point i pass the focus to the other apps window.

it sucks!!! well done XP developers

 

[Jan De Messemaeker]

Hi,

This newsgroup is for Microsoft Project. YOu might have more support in an
Excel newsgroup.
Greetings,

 

[Guest]

sorry was looking for a VBA group thougt project meant a
as a VBA project

thanks