KIDASA Software Q&A Center
Click here to see this page in full context

Add tags to a schedule using Excel

Question:     

I want to use a table of unique IDs that I have in Excel to update the unique IDs on my Milestones schedule.  How do I do this?

 

Answer:

 

  1. Go to this page on the KIDASA web site:  Excel Examples.
  2. Click to expand Excel VBA Example #6.
  3. Scroll down until you see the link for MilestonesOLEExcelExample6.zip.  Click the link you see and download.
  4. Navigate to the download location (usually your Downloads folder.)
  5. Expand the zip file to a folder.
  6. In the folder, right-click MilestonesOLEExcelExample6.xls  and choose Properties.
  7. On the General tab,  near the bottom,  Unblock.  
  8. Double-click to open the MilestonesOLEExcelExample6.xls file.
  9. Click the Enable Editing button.
  10. Right click the Excel toolbar and choose Customize Ribbon.
  11. On the right site,   Developer tab.  This will turn on the Developer tab, necessary for VBA.
  12. On the Developer tab, click Macros to show a list of available macros.
  13. Click TagMilestonesSchedule to run the macro.  You will be prompted to specify the Milestones file which is to be updated.  

 

Here's what the sample excel file looks like.  It can easily be edited with the Unique IDs to be used.

 

 

View a movie on this topic.