Hi All,
Thanks for replying to my dilemma. I "think" i know where the problem is.
The report that I am getting is opened and viewed in Internet Explorer
[VBA]
Workbooks.Open Filename:= _
"http://xxxxx.xxxxx.com/xxxxx/cpcirs/xxxxx/" & ReportName & " "
[/VBA]
i used the appactivate method to select the window; now i'm trying to figure out how to select a cell in the window. hopefully that won't be too hard.
[VBA]
AppActivate ("http://xxxxx.xxxxx.com/xxxxx/xxxxx/xxxxx/" & ReportName & " - Microsoft Internet Explorer")
[/VBA]

again, thanks for all the input