appactivate

[Philip Kopf]

I am trying to create some VBA in Excel that gathers data
from another application and brings it back into excel.
I can get the VBA code to do this but I can't get the
excel to display on top over the application that I
gathered the other info from. Does anyone know how to
make the excel spreadsheet be ontop again?

 

[Tom Ogilvy]

Look at the appactivate command.

 

[mudraker]

Philip

I have used

AppActivate "Microsoft Excel"


Help file also says you can use

AppActivate ReturnValue

if you shelled the other app

 

[Philip Kopf]

-----Original Message-----
I am trying to create some VBA in Excel that gathers data
from another application and brings it back into excel.
I can get the VBA code to do this but I can't get the
excel to display on top over the application that I
gathered the other info from. Does anyone know how to
make the excel spreadsheet be ontop again?
.