Hi all. I am doing some Excel VBA programming for an engineering group
in the area of production scheduling. Most of it is going OK but they
have some ideas for a bit of a dream tool. Eventually this stuff will
be replaced by SAP APO, but right now it is all in Excel.

They want to show visually the status of various schedules, in a format
very similar to a gantt chart in MSProject. Each day they want to play
with the schedules, taking one schedule and lengthening it or
shortening it not by changing the data, but by dragging the actual
schedule itself longer or shorter.

Can this be done in Excel?
Should I be trying to use an MSProject control through ActiveX?
Is there a simpler and more suitable ActiveX control anyone can
recommend?

Maybe the the control would need to be bound to the data in the
underlying cells somehow (don't know how this would work)?

Say you had dates in coloumns across the top of the sheet. The control
would basically be a coloured rectangle that the user can stretch to
cover 3 days instead of two if the schedule slips - or shorten to one
day if the ship is loaded quicker than expected. It's hard to explain
in words - anyway, like a Gantt chart.

Any ideas?
Thanks
Simon Cullen
Simon.Cullen@ BHPBilliton.com (remove the space to reply)

Charts can be used to adjust the underlying values by dragging in the chart
itself.

Here is information on Gantt charts in excel (the first is manual, the
others are using code)

http://support.microsoft.com/default...b;en-us;213915
How to create a Gantt chart using hours as the scale

http://support.microsoft.com/?id=123260
XL: Visual Basic Module to Create Gantt Chart

http://support.microsoft.com/default...&Product=xlw2K
XL: Visual Basic Module to Create a Gantt Chart

http://support.microsoft.com/default...&Product=xlw2K
INFO: Gantt Chart Sample Add-In Available for Download

--
Regards,
Tom Ogilvy



wrote in message
ps.com...
Hi all. I am doing some Excel VBA programming for an engineering group
in the area of production scheduling. Most of it is going OK but they
have some ideas for a bit of a dream tool. Eventually this stuff will
be replaced by SAP APO, but right now it is all in Excel.

They want to show visually the status of various schedules, in a format
very similar to a gantt chart in MSProject. Each day they want to play
with the schedules, taking one schedule and lengthening it or
shortening it not by changing the data, but by dragging the actual
schedule itself longer or shorter.

Can this be done in Excel?
Should I be trying to use an MSProject control through ActiveX?
Is there a simpler and more suitable ActiveX control anyone can
recommend?

Maybe the the control would need to be bound to the data in the
underlying cells somehow (don't know how this would work)?

Say you had dates in coloumns across the top of the sheet. The control
would basically be a coloured rectangle that the user can stretch to
cover 3 days instead of two if the schedule slips - or shorten to one
day if the ship is loaded quicker than expected. It's hard to explain
in words - anyway, like a Gantt chart.

Any ideas?
Thanks
Simon Cullen
Simon.Cullen@ BHPBilliton.com (remove the space to reply)