appactivate
 

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?

appactivate
 

Look at the appactivate command.

--
Regards,
Tom Ogilvy

"Philip Kopf" wrote in 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?

appactivate
 

Philip

I have used

AppActivate "Microsoft Excel"


Help file also says you can use

AppActivate ReturnValue

if you shelled the other app


---
Message posted from http://www.ExcelForum.com/

appactivate
 

-----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?
.