One member of our team wrote an Excel macro to create data and then import it
into MSProject and save it as a mpp file. We currently have 6 people using
the program and 4 of us have no problems. One of the others gets an error
message when he runs the macro.

The line that causes the problem is
BaseCalendarCreate Name:="Holiday Calendar"

The error is Run time error 1100, "This method is not available in this
situation"

I have checked the VBA references on the non-working machine and they match
what is on mine (where it works fine).

The previous line in the code is
FileOpen Name:="\\Fil\" & Department & " Project Schedule.xls",
ReadOnly:=False, Merge:=0, Map:="Map 99"

Does anyone have any ideas of what is causing this and what to do about it?