Error Handling using Getdata

[Climbo]

Hello there,

I am puzzled, can someone explain :

when running I get Error :
The File name, sheet name or range is invalid of : "my path and file name"
... which is normal since the file isnt there.

thing is I am trying to trap the error when file is missing with :
on error goto ErrorHandler

and I still get the error msg but i'm not redirected to Error Handler

I tested my "on error goto" with "Error 11", just to simulate error and then I am directed to ErrorHandler but it seems that the error I'm getting with my "GetData" statment isnt recognized as an error....

-------------------------
On Error GoTo ErrorHandler
GetData FilePath & AgentPath & MonthPath & Worksheets("ReportGenerator").Range("AC2") & ".xls", "Report", "B3:O9", Sheets("Jan").Range("B2"), True, True
--------------------------

Thanks,
Climbo.

[Wheres_the_Red]

GetData . . . . is this the getData that requires the string to describe a single cell in the PivotTable report??

Are you sure that your string does this??

I'd be putting a breakpoint over your OnError and stepping through the code live.

I think you'll find that it's pretty tough for VBA to find the error if your strings don't specify a valid pivot tabel (or worse) . . .

Failing that, run the code with a msgbox above the GetData, to show you what the strings say, then to show wat the values are.

If you still have trobuel, post the file so it can be checked for you!!!!!