MSProject Template failing
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? |
MSProject Template failing
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? |
MSProject Template failing
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? |
All times are GMT +1. The time now is 10:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com