Excel OLE Automation Example #5
This example uses OLE Automation to generate schedule for a specific resource, taken from an Excel spreadsheet:
User runs the VBA macro "MakeMiles"
A form is populated with available Resource Names from the spreadsheet.
User selects the desired resource name
MakeMiles" creates a Milestones schedule of that resource's tasks
To try this example
The Milestones Professional Schedule:
To try this example:
If you would like to try this example, do this:
"Unzip" the file to a folder on your computer.
Start Excel and open the MilestonesOLEExcelExample5.xls file.
In Excel, choose Macro on the Tools menu, then choose Macros.
Click to select the "MakeMiles" macro.
Click the run button.
(This download is recommended for those familiar with Visual Basic and Microsoft Excel).
to visit our main programmer's page.