Author | IMSI/SoftDev | [Prev] [Next] by Author |
Category | Import/Export Data | [Prev] [Next] by Category |
Keywords: | ||
Type (Source?) | Macro (VBA) | |
Licence | Example | |
Status | To be reviewed |
Description
This example shows how to launch Excel® from a TurboCAD VBA macro, open an Excel spreadsheet file and create a multiline from the data within the file.
This macro uses the following objects: Drawing, Graphic and Graphics.
Remarks
Make sure you set up the correct path for the Excel file in the macro before running it.
Build Instructions
Download and unzip the archive. Two files are included: ExcelImport.tcm and TurboCADv6.xls. Add a new project named "ExcelImport" to any TurboCAD drawing, and attach the ExcelImport.tcm file. Run the VBA Editor and change the path for the xls data file. Run the Run_Import macro.
Note, you have to adjust the path the spreadsheet file at the start of the macro.