Executing VBA Code

[David M C]

Is it possible to execute code via a shortcut from the desktop without
opening Project? The user can be prompted for the location of the project
file.

Thanks

Dave

 

[John]

Is it possible to execute code via a shortcut from the desktop without
opening Project? The user can be prompted for the location of the project
file.

Thanks

Dave

Dave,
No. VBA code can only be executed from an application (hence the "A" in
"VBA"). However, visual basic code can be executed independently of any
application if the code is created using a separate application such as
VB6 or VB.net.

John
Project MVP

 

[David M C]

So if I coded a vastly simplified GUI, with a few simple forms to modify
project progress etc, I can still have access to the project file? The people
who will be updating project progress aren't completely computer literate. A
simple GUI would reduce the training burden.

I've never programmed in VB and have no idea of its limitations. I come from
a C/C++ and Java background.

 

[John]

So if I coded a vastly simplified GUI, with a few simple forms to modify
project progress etc, I can still have access to the project file? The people
who will be updating project progress aren't completely computer literate. A
simple GUI would reduce the training burden.

I've never programmed in VB and have no idea of its limitations. I come from
a C/C++ and Java background.

David,
Yes, the simple GUI approach created by Visual Basic would work, but
then so would a simple GUI created by C/C++ or any other language that
can interface with the Project object model. I've never delved into
standalone Visual Basic or other languages so I don't know how difficult
it might be to write the code but it shouldn't be two bad as long as you
know the Project object model and how to access it. Try posting again
(new post) on that subject. Some of my fellow MVPs are likely to have
experience that could help you.

I don't know if you are interested but Project also has a Server version
that features PWA (Project Web Access). I don't know anything about it
other than it is structured to allow users to update projects using a
web interface. For more information on Server, take at look at
Microsoft's website and search for Project Server, or you can post on
our sister newsgroup:
microsoft.public.project.server

Hope this helps.
John
Project MVP