Re: How to capture MsgBox result and paste into Excel

Hi Mike,
You have responsed three times to posts of mine and every time you tell me
to post on the server or developer list. I try and post my questions on the
Highest level Microsoft Project list level so it will go to all three
subordinate lists (including the developer and server lists). Does the post
not work this way?

"Mike Glen" wrote:

>
> Hi Marty ,
>
> Try posting on the developer newsgroup. Please see FAQ Item: 24. Project
> Newsgroups. FAQs, companion products and other useful Project information
> can be seen at this web address: http://www.mvps.org/project/.
>
> Mike Glen
> Project MVP
>
>
> wrote:
> > I have generated a number of VBA modules that count various types of
> > tasks in a project and display the count total in a Message box. But
> > there doesn't appear to be a way to copy or cut the number out of the
> > message box. How do I get the total number out of the message box
> > and pasted into Excel? Or how do I get the total count some other
> > way in project so I can paste it into Excel? A sample of my VBA code
> > is below.
> >
> > Sub Total_Completed_Number_of_Tasks()
> > Dim T As Task
> > Dim C As Long
> >
> > For Each T In ActiveProject.Tasks
> > If Not (T Is Nothing) Then
> > If T.Summary = False Then
> > If T.PercentComplete = 100 Then
> > C = C + 1
> > End If
> > End If
> > End If
> > Next T
> >
> > MsgBox Prompt:="The Project Contains " _
> > & C & " Completed non-Summary tasks"
> >
> > End Sub
>
>
>
>
.

Relevant Pages

  • Re: How to capture MsgBox result and paste into Excel
    ... Thanks Mike, ... Questions, Server, and Developers/Programmers are indented under the Higher ... > correct newsgroup to attract answers from the experts in that field, ... >>> tell me to post on the server or developer list. ...
    (microsoft.public.project)
  • Re: Problem finding website files.
    ... WSS but am trying to find the actual sites files (like ... of Server 2003. ... can't find the folder or even a folder titled "Lists". ... >Mike Walsh, Helsinki, Finland ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: How to capture MsgBox result and paste into Excel
    ... > subordinate lists (including the developer and server lists). ... newsgroup and not realize that another MVP is responding to the same ...
    (microsoft.public.project)
  • Re: newbie - Proper User of AD as Address Book
    ... it is strange that nobody offers hosted LDAP address books. ... To make the contact lists more tied to a user, ... Since you're a c# developer, you may also want to look at the S.DS ... emails on the server and I can get at all of them under any OS I want. ...
    (microsoft.public.windows.server.active_directory)
  • Re: hacked server
    ... It has a GUI and lists all things that are ... Another great tool is the process explorer. ... > Check if there are any unknown user accounts created on server. ...
    (microsoft.public.windows.server.security)