Lists

Open Menu Close Menu

Terms and Conditions
Lists hosted on this site
Email the Postmaster
Tips for posting to public mailing lists

Auto Resize columns on opening a text file in Excel

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Auto Resize columns on opening a text file in Excel

Subject: Auto Resize columns on opening a text file in Excel
From: Spelean <email@hidden>
Date: Thu, 08 Dec 2011 13:10:42 +1100

Title: Auto Resize columns on opening a text file in Excel

I'm creating tab delimited text files from a database.

I'd like Excel to auto resize the columns to the max width in each column after opening.

This is akin to selecting all the columns manually and then double clicking the column divider in the header

Is there an inbuilt applescript command that will do this?

something like

set column width of cell "A1:AD1" to (auto) ?

Andrew Pavey

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users

This email sent to email@hidden

Follow-Ups:
- Re: Auto Resize columns on opening a text file in Excel
  - From: Paul Berkowitz <email@hidden>
- Re: Auto Resize columns on opening a text file in Excel
  - From: Stan Cleveland <email@hidden>

Prev by Date: Re: [Help !!!] Apple Script Xcode 4, thank you so much
Next by Date: Re: Auto Resize columns on opening a text file in Excel
Previous by thread: How to tell applescript to debug Xcode project (On Xcode 4)
Next by thread: Re: Auto Resize columns on opening a text file in Excel
Index(es):
- Date
- Thread