AutoFit Selection

[Guest]

I have downloaded some data from a webpage into Excel. The data is put into excel and is still highlighted. However the user needs to do Format -> Column -> AutoFit Selection

How can I get my javascript to automatically do this?

SCRIPT LANGUAGE="JScript">

function bringToExcel(src)
{
document.selection.clear;
txt = eval(src +".innerText");
theObj = document.all(txt);
txtRange = document.body.createTextRange();
txtRange.moveToElementText(eval(src));
txtRange.select();
// uncomment line below to use with formatted (innerHTML) text
// txtRange.execCommand("RemoveFormat");
txtRange.execCommand("Copy");
txtRange.execCommand("UnSelect", false);

false);
var oXL = new ActiveXObject("Excel.Application");
oXL.Visible = true;
var oWB = oXL.Workbooks.Add();
var oSheet = oWB.ActiveSheet;
oSheet.Paste();
oXL.Visible = true;
oXL.UserControl = true;
}

**************************
I need a line after the oSheet.Paste(); to tell it to autofit the selection. What is the syntax for this?

 

[Juan Pablo González]

Try with

oSheet.Cells.EntireColumn.AutoFit

 

[Guest]

Many Juan thanks, it worked!