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?

Hi raviyah,

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

clb

"raviyah" wrote:

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?

The holiday calendar is available to the user

"C" wrote:

Hi raviyah,

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

clb

"raviyah" wrote:

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?