Manage web generated reports

  • Thread starter Thread starter John Bundy
  • Start date Start date
J

John Bundy

Hello all! I have code that is navigating to a site, logging in, and
submitting several queries that generate excel and access reports, these
reports automatically open upon completion. What I want to do is grab a
report as it finishes and save it to a location depending on the name of the
file. I have the save logic down, but what is the best way to 'see' when a
report has been generated, check its name, and continue with the save? The
only thing i can think of is an application level on open in excel, which
would not be a good method and ignores access altogether. Any help or a
direction is much appreciated.
 
Ok I have done some more research and coding and I have a partial solution, i
can make changes and do a postback. When i postback a workbook opens with the
result. I need to grab this workbook and download it. Another possibility i
thought of is webclient.download, this would do the trick but i don't have
the url to the specfic file. Does anyone know of anything similar that would
let me:
WebClient.Download("postbackdata","filename")
fire the postback and download the result?
Thanks
 
Back
Top