VBA, Newby help

Newby help

Author	Message
Karl #1 / 7	Newby help Please could somebody help a newby VBA guy. What I would like to do is this. Find the first date on the programme, change the view to calendar view and go to the first date on the programme. At the moment when I change the view to calendar it defaults to 1985. Also on a side note is it possible to show summarized tasks on the calendar? Many thanks for you time guys, Karl
Sun, 16 Oct 2005 06:24:14 GMT

Rod Gil #2 / 7	Newby help Hi, Use Tools, Macro, Record new macro to record a macro of you opening the calendar view then using F5 goto to go to a specific date. Use the date Date() to goto today's date. -- Rod Gill Project MVP For Microsoft Project companion projects, best practices and Project VBA development services visit www.projectlearning.com/ Quote: > Please could somebody help a newby VBA guy. > What I would like to do is this. > Find the first date on the programme, change the view to > calendar view and go to the first date on the programme. > At the moment when I change the view to calendar it > defaults to 1985. > Also on a side note is it possible to show summarized > tasks on the calendar? > Many thanks for you time guys, > Karl
Sun, 16 Oct 2005 13:37:08 GMT

Karl #3 / 7	Newby help Thanks Rod Have used Record macro. so going into the calendar view is not really a big problem, my problem is that i would like to identify the first date on the programme (this my change depending on the filter i create/Run) i would then use this date in the calendar view, as you stated my pressing f5 then using this date to go to. how do i get the first date in the programme? how do i code that as the date i would like the calendar view to go to. Many thanks for your help Karl Quote: >-----Original Message----- >Hi, >Use Tools, Macro, Record new macro to record a macro of you opening the >calendar view then using F5 goto to go to a specific date. Use the date >Date() to goto today's date. >-- >Rod Gill >Project MVP >For Microsoft Project companion projects, best practices and Project VBA >development services >visit www.projectlearning.com/ >> Please could somebody help a newby VBA guy. >> What I would like to do is this. >> Find the first date on the programme, change the view to >> calendar view and go to the first date on the programme. >> At the moment when I change the view to calendar it >> defaults to 1985. >> Also on a side note is it possible to show summarized >> tasks on the calendar? >> Many thanks for you time guys, >> Karl >.
Sun, 16 Oct 2005 16:50:13 GMT

Rod Gil #4 / 7	Newby help Hi, The first date in the schedule should be the project start date: activeproject.ProjectStart -- Rod Gill Project MVP For Microsoft Project companion projects, best practices and Project VBA development services visit www.projectlearning.com/ Quote: > Thanks Rod > Have used Record macro. > so going into the calendar view is not really a big > problem, my problem is that i would like to identify the > first date on the programme (this my change depending on > the filter i create/Run) i would then use this date in the > calendar view, as you stated my pressing f5 then using > this date to go to. > how do i get the first date in the programme? > how do i code that as the date i would like the calendar > view to go to. > Many thanks for your help > Karl > >-----Original Message----- > >Hi, > >Use Tools, Macro, Record new macro to record a macro of > you opening the > >calendar view then using F5 goto to go to a specific > date. Use the date > >Date() to goto today's date. > >-- > >Rod Gill > >Project MVP > >For Microsoft Project companion projects, best practices > and Project VBA > >development services > >visit www.projectlearning.com/ > >> Please could somebody help a newby VBA guy. > >> What I would like to do is this. > >> Find the first date on the programme, change the view to > >> calendar view and go to the first date on the programme. > >> At the moment when I change the view to calendar it > >> defaults to 1985. > >> Also on a side note is it possible to show summarized > >> tasks on the calendar? > >> Many thanks for you time guys, > >> Karl > >.
Mon, 17 Oct 2005 10:23:46 GMT

Karl #5 / 7	Newby help Rod, Tried this but did not work the first date was the 14/3/2003 but ActiveProject.ProjectStart says the 1/1/2003 Sub CAL_GOTO() ' Macro CAL_GOTO Dim FIRST_DATE As Variant FIRST_DATE = ActiveProject.ProjectStart ViewApply Name:="&Calendar" EditGoTo Date:=FIRST_DATE End Sub Many thanks Quote: >-----Original Message----- >Hi, >The first date in the schedule should be the project start date: >activeproject.ProjectStart >-- >Rod Gill >Project MVP >For Microsoft Project companion projects, best practices and Project VBA >development services >visit www.projectlearning.com/ >> Thanks Rod >> Have used Record macro. >> so going into the calendar view is not really a big >> problem, my problem is that i would like to identify the >> first date on the programme (this my change depending on >> the filter i create/Run) i would then use this date in the >> calendar view, as you stated my pressing f5 then using >> this date to go to. >> how do i get the first date in the programme? >> how do i code that as the date i would like the calendar >> view to go to. >> Many thanks for your help >> Karl >> >-----Original Message----- >> >Hi, >> >Use Tools, Macro, Record new macro to record a macro of >> you opening the >> >calendar view then using F5 goto to go to a specific >> date. Use the date >> >Date() to goto today's date. >> >-- >> >Rod Gill >> >Project MVP >> >For Microsoft Project companion projects, best practices >> and Project VBA >> >development services >> >visit www.projectlearning.com/ >> >> Please could somebody help a newby VBA guy. >> >> What I would like to do is this. >> >> Find the first date on the programme, change the view to >> >> calendar view and go to the first date on the programme. >> >> At the moment when I change the view to calendar it >> >> defaults to 1985. >> >> Also on a side note is it possible to show summarized >> >> tasks on the calendar? >> >> Many thanks for you time guys, >> >> Karl >> >. >.
Mon, 17 Oct 2005 18:00:24 GMT

Jan De Messemaeke #6 / 7	Newby help As posted elsewhere as well Activeproject.projectsummarytask.start That does it. -- Jan De Messemaeker Microsoft Project Most Valuable Professional Project Management Consultancy Prom+ade BVBA 32-495-300 620 Quote: > Rod, Tried this but did not work the first date was the > 14/3/2003 but ActiveProject.ProjectStart says the 1/1/2003 > Sub CAL_GOTO() > ' Macro CAL_GOTO > Dim FIRST_DATE As Variant > FIRST_DATE = ActiveProject.ProjectStart > ViewApply Name:="&Calendar" > EditGoTo Date:=FIRST_DATE > End Sub > Many thanks > >-----Original Message----- > >Hi, > >The first date in the schedule should be the project > start date: > >activeproject.ProjectStart > >-- > >Rod Gill > >Project MVP > >For Microsoft Project companion projects, best practices > and Project VBA > >development services > >visit www.projectlearning.com/ > >> Thanks Rod > >> Have used Record macro. > >> so going into the calendar view is not really a big > >> problem, my problem is that i would like to identify the > >> first date on the programme (this my change depending on > >> the filter i create/Run) i would then use this date in > the > >> calendar view, as you stated my pressing f5 then using > >> this date to go to. > >> how do i get the first date in the programme? > >> how do i code that as the date i would like the calendar > >> view to go to. > >> Many thanks for your help > >> Karl > >> >-----Original Message----- > >> >Hi, > >> >Use Tools, Macro, Record new macro to record a macro of > >> you opening the > >> >calendar view then using F5 goto to go to a specific > >> date. Use the date > >> >Date() to goto today's date. > >> >-- > >> >Rod Gill > >> >Project MVP > >> >For Microsoft Project companion projects, best > practices > >> and Project VBA > >> >development services > >> >visit www.projectlearning.com/ > >> >> Please could somebody help a newby VBA guy. > >> >> What I would like to do is this. > >> >> Find the first date on the programme, change the > view to > >> >> calendar view and go to the first date on the > programme. > >> >> At the moment when I change the view to calendar it > >> >> defaults to 1985. > >> >> Also on a side note is it possible to show summarized > >> >> tasks on the calendar? > >> >> Many thanks for you time guys, > >> >> Karl > >> >. > >.
Mon, 17 Oct 2005 18:17:41 GMT

Jan De Messemaeke #7 / 7	Newby help -- Jan De Messemaeker Microsoft Project Most Valuable Professional Project Management Consultancy Prom+ade BVBA 32-495-300 620 Quote: > Rod, Tried this but did not work the first date was the > 14/3/2003 but ActiveProject.ProjectStart says the 1/1/2003 > Sub CAL_GOTO() > ' Macro CAL_GOTO > Dim FIRST_DATE As Variant > FIRST_DATE = ActiveProject.ProjectStart > ViewApply Name:="&Calendar" > EditGoTo Date:=FIRST_DATE > End Sub > Many thanks > >-----Original Message----- > >Hi, > >The first date in the schedule should be the project > start date: > >activeproject.ProjectStart > >-- > >Rod Gill > >Project MVP > >For Microsoft Project companion projects, best practices > and Project VBA > >development services > >visit www.projectlearning.com/ > >> Thanks Rod > >> Have used Record macro. > >> so going into the calendar view is not really a big > >> problem, my problem is that i would like to identify the > >> first date on the programme (this my change depending on > >> the filter i create/Run) i would then use this date in > the > >> calendar view, as you stated my pressing f5 then using > >> this date to go to. > >> how do i get the first date in the programme? > >> how do i code that as the date i would like the calendar > >> view to go to. > >> Many thanks for your help > >> Karl > >> >-----Original Message----- > >> >Hi, > >> >Use Tools, Macro, Record new macro to record a macro of > >> you opening the > >> >calendar view then using F5 goto to go to a specific > >> date. Use the date > >> >Date() to goto today's date. > >> >-- > >> >Rod Gill > >> >Project MVP > >> >For Microsoft Project companion projects, best > practices > >> and Project VBA > >> >development services > >> >visit www.projectlearning.com/ > >> >> Please could somebody help a newby VBA guy. > >> >> What I would like to do is this. > >> >> Find the first date on the programme, change the > view to > >> >> calendar view and go to the first date on the > programme. > >> >> At the moment when I change the view to calendar it > >> >> defaults to 1985. > >> >> Also on a side note is it possible to show summarized > >> >> tasks on the calendar? > >> >> Many thanks for you time guys, > >> >> Karl > >> >. > >.
Mon, 17 Oct 2005 18:17:00 GMT

Page 1 of 1

[ 7 post ]