smi4975
15th January 2010, 18:07
I'm trying to call in an external application within the program - Excel using seq.open.local() function.
I'm unable to control the width of the cells to automatically adjust as per the length.
say i have a text field of 45 chars, the cell should automatically adjust to that
Can anyone help how do i do this?

mark_h
18th January 2010, 00:39
I am not sure I understand - are using seq.open.local to open a local excel file and putting text into it? I know I can start excel with a file or a macro, but I do not understand exactly what you are doing. Can you post some code or more of an explanation.

george7a
18th January 2010, 09:15
As Mark said, one way to do that is to write a macro that will auto adjust the column's width.