This is driving me NUTS! This code works just fine in other workbooks, but
something is wrong here. I am getting the error on the last line of code.
Same error when trying to activate the wbkSum workbook too.
Here is the code:

Dim wbkSum As Workbook
Dim wbkData As Workbook
Dim iOffice As Integer

Set wbkSum = Workbooks("My DMR Summary May 2007.xls")
Set wbkData = ActiveWorkbook

Windows("wbkData").Activate