importing data from an excel workbook created from a webserver

[krankyboy]

Hi,

I need to import data from a workbook that is created after navigating to an ASP page. I'm using the getobject function
and can read the worksheet but this is while I'm stepping through the code. The workbook becomes the active window and I have to move back to my VBA code in Access to continue, can't have that!

Is there a way that Excel can be be stopped from being the active window? Or is there some way to open Excel before I go to the ASP and have the excel workbook open, so I can fully control it??

Thanks

Andrew

 

[PHV]

What about the AppActivate instruction ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886