![]() |
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
Guest
Posts: n/a
|
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? |
|
|
|
#2 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Bogota, Colombia
Posts: 11,931
|
Try with
oSheet.Cells.EntireColumn.AutoFit |
|
|
|
|
|
#3 |
|
Guest
Posts: n/a
|
Many Juan thanks, it worked!
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|