VBA and Excel

[axa2001ro]

Hello,


Can you tell me, please how can I format as Text the data type for a column in Excel worksheet, which is opened from AutoCAd ( using VBA)?

Thank you!

[cll]

Hi,

When you have set the excel connection, workbook and worksheet,

Columns("A:A").Select
Selection.NumberFormat = "@"

will do.

Hope this helps.
Best regards

Claus