Forum Discussion

Gilgamesh1964's avatar
Gilgamesh1964
Brass Contributor
Nov 15, 2021
Solved

MS Project VBA Default Location and Default AutoScheduled tasks

Hello, I have two VBA related questions for MS Project.   1) How do I find the Default File Location? In Excel it is easy with Application.DefaultFilePath but I can't seem to find an equivalent i...
2016
Project
  • John-project's avatar
    John-project
    Nov 16, 2021

    Gilgamesh1964,

    It is a little strange about the auto/manual scheduling option not being available via VBA, all the other scheduling options are.

     

    Yes, you can set auto/manual in the registry. This is what it looks like on my PC, which is currently set for auto schedule.

    John

Gilgamesh1964's avatar
Gilgamesh1964
Brass Contributor
Nov 24, 2021

John-project 

Hi
Sorry for taking so long to get back (non schedule based project work got in the way :smile:).

No I hadn't added a line to save the project. I would have thought as I'm changing the default for new schedules then a save of the current one would not be necessary.

However I added one, and this is where we now enter the Twilight Zone.

New schedules were being created with Auto Scheduled tasks as desired. But when looking at the MS Project settings it was still showing Manual Scheduled as the default setting for new schedules ????

Changing this MS Project setting in the standard GUI interface no longer had any effect, I would set it for Auto Scheduled, Leave, and upon going back in it said Manually Scheduled again. Yet new schedules continued to be created as Auto Scheduled.

I managed to restore normal functionality by using RegEdit to restore the setting, and I think I'll stick with manual instructions to get this setting as desired.

John-project's avatar
John-project
Silver Contributor
Nov 24, 2021
Yeah I remember that episode, I think it was 1963. Oh well, you do what you have to do to make it all work 🙂
Thanks for the feedback.
john

Resources