D
Dale Fye
I've got an Access application that tracks multiple projects, and milestones
along those project timelines. My goal is to create a procedure in my Access
application that will use automation to open Excel, and create a visual
representation of the various projects and their milestones.
My client is playing with the idea of using Project to do this, but
apparantly, Project 2007 does not read Access 2007 data.
I've used Access to populate Excel fields in the past, so I'm somewhat
familiar with the Excel object model, but I have never tried to do anything
like create shapes. What I need to be able to do via code is:
1. Along the top, label the first row with the months
2. Label the second row with individual days, and size those cells
appropriately (I know how to do these)
3. On each successive row.
a. Enter some text in the first cell of the row (no problem)
b. Draw a line (of a certain width and color) from a start date through
an end date associated with the cells in row 2. Don't know how to do this.
How do you identify that a line starts at a certain vertical and horizontal
position in a cell and ends at in another cell on the same "row" of the
spreadsheet.
c. Draw a rectangle, that overlaps this line between two dates (don't
know how to do this, but assume it is similar to b above).
d. Draw a textbox immediately below the rectangle from step c with a
label in it.
Need to make sure that all of these shapes (line, rectangle, textbox) are
associated with the row so that if someon hides the row, all of the shapes
are hidden as well.
I know I can get some of this by recording a macro, but would appreciate any
comments regarding this process.
Dale
along those project timelines. My goal is to create a procedure in my Access
application that will use automation to open Excel, and create a visual
representation of the various projects and their milestones.
My client is playing with the idea of using Project to do this, but
apparantly, Project 2007 does not read Access 2007 data.
I've used Access to populate Excel fields in the past, so I'm somewhat
familiar with the Excel object model, but I have never tried to do anything
like create shapes. What I need to be able to do via code is:
1. Along the top, label the first row with the months
2. Label the second row with individual days, and size those cells
appropriately (I know how to do these)
3. On each successive row.
a. Enter some text in the first cell of the row (no problem)
b. Draw a line (of a certain width and color) from a start date through
an end date associated with the cells in row 2. Don't know how to do this.
How do you identify that a line starts at a certain vertical and horizontal
position in a cell and ends at in another cell on the same "row" of the
spreadsheet.
c. Draw a rectangle, that overlaps this line between two dates (don't
know how to do this, but assume it is similar to b above).
d. Draw a textbox immediately below the rectangle from step c with a
label in it.
Need to make sure that all of these shapes (line, rectangle, textbox) are
associated with the row so that if someon hides the row, all of the shapes
are hidden as well.
I know I can get some of this by recording a macro, but would appreciate any
comments regarding this process.
Dale