get date information programatically in Resource Usage calendar ct

[spencer]

Hello,

I have a question that I hope that someone can help me with. It relates to
the calendar type control that is shown on the right hand side of the
resource usage view. When I press F6 the focus switches from the grid on the
left to the calendar on the right. I would like to be able to pop a message
box that shows the date of that cell and whether the focus is in the work or
actual work row. I tried querying the ActiveCell object but this seemed to
give me details of the active cell in the data table on the left not the
active cell in the calendar type area on the right. This is with Project
2007. It may seem a pointless request but it is for a visually impaired
computer user who cannot simply look up and left to get this information.

I would be very grateful for any advice that anyone could offer on this.

Thanks in advance for any help

Spencer

 

[Rod Gill]

I'm not aware of any way this can be done with VBA. You may need to export
to Excel and then use Excel VBA to do this as Excel can easily be made to
show column and row headers.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[spencer]

Hello Rod,

Thank you for yor response, as my initial way wouldn't wwork I have been
investigating different ways to work around the problem. I can do something
with the screen reader but need the calendar type control set to a particular
view. Please could you tell me if there is a way to programmatically achieve
the following method.

I right click on the date header in the resource table calendar view (this
opens the timescale window). I then select the Middle Tier tab and change
Units to Days and under Timescale options change the value of Show to be One
Tier (Middle).

Ideally I would like a macro that automates these steps so that when the
user runs it it changes the layout to this view type if not already.

Thank you in advance for any advice you can offer

Spencer

 

[Rod Gill]

Try recording a macro of you changing the timescale, it should give you the
code you need.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[spencer]

That worked brilliantly. I should have thought of that myself but never
considered the simple recording solution. Thank you very much for your help
with this.

 

[Rod Gill]

No problem, record macro can be a great time saver. If nothing gets
recorded, it often means VBA can't do the action.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com