Exporting Web-Select Projects to AutoCAD

1. In Web-Select, highlight the appropriate area on the project schedule that you wish to create a spreadsheet/schedule. Right click on the highlighted area and select copy. This will copy the highlighted contents to your Windows clipboard.
2. Open Microsoft Excel, go to the edit menu, select paste. This will paste the clipboard contents into Excel. You should now see the new spreadsheet/schedule in Excel. Make sure this is the textual information you want to appear in your AutoCAD drawing.
3. In Excel, go to the file menu, select Save As, go to the drop down menu under Save As Type, select Formatted Text (Space delimited) (*.prn). Save this file to an appropriate name and place on your hard drive or network file server. You may get two prompts immediately after the Save As operation, answer yes to both.
4. Open AutoCAD, open the drawing that you want the spreadsheet/schedule textual information to appear in.
5. In AutoCAD make sure that your current text style has a font assignment that is a mono-spaced font. A default AutoCAD installation supplies only one standard mono-spaced font, which is monotxt.shx. Make sure that you have the appropriate layer set current.
6. In AutoCAD, issue the Mtext command. Select the first corner and opposite corner, the Multi-line text editor dialog will appear. Click the Import text button, go to the drop down menu under Files of type, select all files, locate and select the previously saved spreadsheet/schedule text file (*.prn), click the open button, click the OK button. Your spreadsheet/schedule should now appear on your AutoCAD drawing. Depending on the size of the spreadsheet/schedule, you may need to adjust the size of the Mtext area assignment. To do this, simply click on the text, grips will appear (four blue corners are default). Select one of the blue grips on the right side and move to achieve the desired result.
7. In AutoCAD, you can now draw the line-work as desired to complete the schedule and to conform to your company's graphic standards. This will take no longer than 5 minutes for a good CAD operator. If you standardize on schedule formats, you can insert the lines as a block for future schedules/projects.