Resize an Excel Column from VB
 

Hi,


I'm using Office XP and I'm trying to use VB (from Access) to resize a
columns in Excel based on the text (size to fit). How can I do this?


Thanks in advance.

Resize an Excel Column from VB
 

Dim ws As Excel.Worksheet

Set ws = oXLApp.Worksheets("Your worksheet name")
ws.Columns("A:A").EntireColumn.AutoFit


This assumes that you have some reference to the application, which is
oXLApp in this sample code.