how to run the marco in excel sheet using tcl

[jloh81]

Hi,
I am trying to run the marco in the excel sheet using TCL script.

Below code is trying to open multiple csv file and run the marco to combine the 2 csv file into one excel sheet

package require tcom

set excel [::tcom::ref createobj Excel.Application]

set workbooks [$excel Workbooks]

set workbook [$workbooks Open book1.csv book2.csv]

$excel Run marco1

$workbook SaveAs book2.excel

BUT, when i run this script, it cannot find package require tcom.
Please advice

 

[mikrom]

tcom could be installed using teacup:

teacup install tcom

 

[jloh81]

hi mikrom,

what is it means? Is it mean that i need to install the tcom?

what is means by teacup install tcom?

I am new to tcl script.

 

[mikrom]

You have written that "it cannot find package require tcom", therefore I think that your Tcl installation doesn't contain the package tcom.

I'm using ActiveTcl 8.5, which doesn't contain tcom by default and so to access a database using ADO I had to install it first, ... and I installed it with method above. It's the command, which you should write on command line and then press enter.

Read here about teacup:

http://wiki.tcl.tk/17305