appactivate

P

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

mudraker

Philip

I have used

AppActivate "Microsoft Excel"


Help file also says you can use

AppActivate ReturnValue

if you shelled the other app
 
P

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?
.
Click to expand...
 
Top