Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AppActivate runtime error 5 when used with shell cmd | Excel Programming | |||
Running a .bat file via AppActivate | Excel Programming | |||
AppActivate problem when called twice | Excel Programming | |||
AppActivate trouble... | Excel Programming | |||
appactivate sendkeys not working with accelerator | Excel Programming |