Timescale Export

[jack_t]

I am new to VBA. I would like to export the following data from resource
usage view in the format below:

WBS Resource Jan Feb
1.1.1 J. Doe 80 hrs 60 hrs

Any tips and assistance are appreciated.

 

[Rod Gill]

Hi,

Use the TimeScaleData method on either a Resource or task to do this. Help
has some sample code.

--

Rod Gill
Microsoft MVP for Project

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

 

[John]

I am new to VBA. I would like to export the following data from resource
usage view in the format below:

WBS Resource Jan Feb
1.1.1 J. Doe 80 hrs 60 hrs

Any tips and assistance are appreciated.

jack_t,
If you are new to Project VBA but really interested in learning how to
use it, I think Rod was a little bit timid in his response. His post
does indirectly mention his book on Project VBA, but if you want to take
advantage of a greatly expanded functionality for Project, I highly
recommend Rod's book. It is well worth it.

John
Project MVP

 

[Rod Gill]

Aw John, [me coyly blushing and scuffing feet]!

--

Rod Gill
Microsoft MVP for Project

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

 

[jack_t]

I just ordered the book! In the meantime, could you tell me what I am doing
wrong with this code? I need to call out an Excel range.

dim x as excel.range

I got an error message ("User defined type not defined").

Thank you.

Aw John, [me coyly blushing and scuffing feet]!

--

Rod Gill
Microsoft MVP for Project

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

jack_t,
If you are new to Project VBA but really interested in learning how to
use it, I think Rod was a little bit timid in his response. His post
does indirectly mention his book on Project VBA, but if you want to take
advantage of a greatly expanded functionality for Project, I highly
recommend Rod's book. It is well worth it.

John
Project MVP

 

[CB]

Try this instead:
Dim xlR As Excel.Range
CB

I just ordered the book! In the meantime, could you tell me what I am doing
wrong with this code? I need to call out an Excel range.

dim x as excel.range

I got an error message ("User defined type not defined").

Thank you.

Aw John, [me coyly blushing and scuffing feet]!

--

Rod Gill
Microsoft MVP for Project

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

I am new to VBA. I would like to export the following data from resource
usage view in the format below:

WBS Resource Jan Feb
1.1.1 J. Doe 80 hrs 60 hrs

Any tips and assistance are appreciated.

jack_t,
If you are new to Project VBA but really interested in learning how to
use it, I think Rod was a little bit timid in his response. His post
does indirectly mention his book on Project VBA, but if you want to take
advantage of a greatly expanded functionality for Project, I highly
recommend Rod's book. It is well worth it.

John
Project MVP

 

[Rod Gill]

You need in the VBE to add a reference to Excel, then Excel.Range will work

--

Rod Gill
Microsoft MVP for Project

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

I just ordered the book! In the meantime, could you tell me what I am
doing
wrong with this code? I need to call out an Excel range.

dim x as excel.range

I got an error message ("User defined type not defined").

Thank you.

Aw John, [me coyly blushing and scuffing feet]!

--

Rod Gill
Microsoft MVP for Project

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

I am new to VBA. I would like to export the following data from
resource
usage view in the format below:

WBS Resource Jan Feb
1.1.1 J. Doe 80 hrs 60 hrs

Any tips and assistance are appreciated.

jack_t,
If you are new to Project VBA but really interested in learning how to
use it, I think Rod was a little bit timid in his response. His post
does indirectly mention his book on Project VBA, but if you want to
take
advantage of a greatly expanded functionality for Project, I highly
recommend Rod's book. It is well worth it.

John
Project MVP