This task shows you how to
extract bending data from bendable pipes, tubes, conduits and waveguides and transfer it into a Microsoft Excel
worksheet. Bending data can be fed into bending machines to precisely create bends in
bendable tubes and pipes.
The standard macro supplied with this product displays bending data in a sample
format. However, a user with some Microsoft VBScript experience can change the script
supplied to change the format.
The sample script assumes that the bendable objects are placed on a run under a
distribution system or a logical line.
For more information on placing parts, see Placing
a Part.
1.
Using Windows Explorer, locate the intel_a\code\command
subdirectory.
2.
Copy the files PslTubingExtract.CATScript
and
PslTubingExtractTemplate.xls to C:\temp (with
read-write access). Select the two files and click the right mouse button. Click Properties in the drop-down
menu that displays. The Properties dialog box will display. Uncheck the Read-Only option.
3.
In the specifications tree, select the
line (piping or tubing) under which the run containing the bendable objects has been placed.
4.
Click Tools - Macro - Macros. The
Macro dialog box will display. Select External
File from the drop down list, select PslTubingExtract.CATScript
and click Select. The Select External
File dialog box will display. Select PslTubingExtract.CATScript
and click Open. This will again display the Macro dialog box. Select PslTubingExtract.CATScript
and click Run. Data will be extracted from the bendable
objects and displayed in an Excel worksheet, part of which is displayed below.
(The application will
create the table, but you must have Excel installed!)