hi Norie,

I'll try your suggestion and get back to you.
The file i'm opening is on an intracompany website. the file is created from a query on a mainframe application using the user's input id as the filename output.
my idea was to have this code work for all users. the reportname is the string that i grab from the mainframe prior to the generation of the report. then i have to go to the website to retrieve the data.

zach