Excel Import

AuthorIMSI/SoftDev [Prev] [Next] by Author
CategoryImport/Export Data [Prev] [Next] by Category
Keywords:
Type (Source?)Macro (VBA)
LicenceExample
StatusTo be reviewed


Description:

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.

This macro should be available in your 'Macros' folder

Comments:




Download: .../IMSI/VBA/ExcelImport.zip (12KB)
More Info: http://www3.imsisoft.com/turbocad/tcsdk/


Email Comment. Use this link to email comments, corrections, additional information etc for this topic.

URL of this page: <A href ='http://www.bcitool.com/TCDRC/?Pages/Page_00158.htm' target = '_blank'>TCDRC - Page 00158</A>