Hi:

I have a macro in excel 2003 that aggregates content from other excel
files and puts data into one spreadsheet.

It works in excel 2003, however does not work in excel 2007.  In excel
2007 I receive the following message:

"the file name, sheet name or Range is invalid of "

Here is a sample of the code that I am using:

GetData ThisWorkbook.Path & "\competitive\uv\ca.xls", "Sheet1", _
           "c12:p21", Sheets("UV PV  TM AMPV Data").Range("b2"),
False, False
   GetData ThisWorkbook.Path & "\competitive\uv\ca.xls", "Sheet1", _
           "d10:p10", Sheets("Summary Raw Data").Range("b237"),
False, False
   GetData ThisWorkbook.Path & "\competitive\pv\ca.xls", "Sheet1", _
           "c12:p21", Sheets("UV PV  TM AMPV Data").Range("b14"),
False, False
   GetData ThisWorkbook.Path & "\competitive\tm\ca.xls", "Sheet1", _
           "c12:p21", Sheets("UV PV  TM AMPV Data").Range("b26"),
False, False
   GetData ThisWorkbook.Path & "\competitive\ampv\ca.xls", "Sheet1",
_
           "c12:p21", Sheets("UV PV  TM AMPV Data").Range("b38"),
False, False
   GetData ThisWorkbook.Path & "\Country Specific\ca.xls", "Sheet1",
_
           "c13:p49", Sheets("ca").Range("c13"), False, False
   GetData ThisWorkbook.Path & "\demographic\cad.xls", "Sheet1", _
           "b9:n116", Sheets("cad").Range("b9"), False, False

Please provide insight into why this is not working in excel 2007

Thanks,
Eric