smoovebarrett
New Member
- Joined
- May 8, 2017
- Messages
- 10
Hi,
I have a tool I've developed in Excel that ends up building a particular 'timeline' out. Its columns look somewhat like the following:
ActivityID Description Duration StartDate EndDate
It builds out this 'timeline' using inputs gathered from the user in an excel userform, and then processes through VBA that includes a hardcoded 'template' for the timeline buildout.
I would love to be able to place a button on the excel worksheet that creates an MS Project File in the format I specify, using these columns. It would not supplement any existing macro in the workbook, but be a new one.
Any initial direction on code to use to get started would be helpful!
Thanks,
Barrett
I have a tool I've developed in Excel that ends up building a particular 'timeline' out. Its columns look somewhat like the following:
ActivityID Description Duration StartDate EndDate
It builds out this 'timeline' using inputs gathered from the user in an excel userform, and then processes through VBA that includes a hardcoded 'template' for the timeline buildout.
I would love to be able to place a button on the excel worksheet that creates an MS Project File in the format I specify, using these columns. It would not supplement any existing macro in the workbook, but be a new one.
Any initial direction on code to use to get started would be helpful!
Thanks,
Barrett