• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: A Faster Script
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: A Faster Script


  • Subject: Re: A Faster Script
  • From: Doug McNutt <email@hidden>
  • Date: Tue, 6 Apr 2004 07:07:49 -0600

At 01:56 -0700 4/6/04, Walter Ian Kaye wrote:
>What they said. <g> Write to tab-delimited file, and open that into Excel.

Me too.

But remember that Excel macros are fully recordable. If this is going to happen again it's well worth the time to turn on the recorder in Excel while you open the tab separated file. You will probably want to move columns and rows into an existing workbook and perhaps name some ranges. You will be pleasantly surprised how easy it is to record a macro and then make a few changes in VBA.

If all of the input files are already tab-separated you might forget about perl and AppleScript and do the whole thing with Excel.

--
--> If you are presented a number as a percentage, and you do not clearly understand the numerator and the denominator involved, you are surely being lied to. <--
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.


References: 
 >A Faster Script (From: Chip Fillingane <email@hidden>)
 >Re: A Faster Script (From: Walter Ian Kaye <email@hidden>)

  • Prev by Date: [ANN] iMagine Video released
  • Next by Date: Re: Strange Error Reading File
  • Previous by thread: Re: A Faster Script
  • Next by thread: Re: A Faster Script
  • Index(es):
    • Date
    • Thread