MSProject Template failing

[raviyah]

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?

 

[C]

Hi raviyah,

Have you checked to see that the "Holiday Calendar" is available to the
machine that is receiving the error?

clb

 

[raviyah]

The holiday calendar is available to the user

Hi raviyah,

Have you checked to see that the "Holiday Calendar" is available to the
machine that is receiving the error?

clb