• 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: Importing/parsing CSV files
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Importing/parsing CSV files


  • Subject: Re: Importing/parsing CSV files
  • From: "Mark J. Reed" <email@hidden>
  • Date: Wed, 13 Sep 2006 17:07:35 -0400

On 9/13/06, Doug McNutt <email@hidden> wrote:
2) Excel has an option in the Save-as dialog to save in CSV format. It saves only the active worksheet which may require stepping through the sheets.

Right. That's what I'm trying to automate.

VBA isn't much help since I can only run it once I'm already in Excel.
But I was able to translate the VBA code into something that works in
the Windows Script Host, so I'm good for now.    I assume there's also
a way to do it via AppleScript, but I found the VBA code and it was
easy to port to VBScript and thence to JScript (that latter step not
being necessary; I just prefer JavaScript to Visual Basic).

Now that I know what the sequence events looks like from the Excel
object model's POV, I can probably turn it into AppleScript, too.  But
for now this solution is fine.

Thanks!

--
Mark J. Reed <email@hidden>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden


References: 
 >Re: Importing/parsing CSV files (From: has <email@hidden>)
 >Re: Importing/parsing CSV files (From: "Mark J. Reed" <email@hidden>)

  • Prev by Date: Re: Importing/parsing CSV files
  • Next by Date: Re: Rép : Importing/parsing CSV files
  • Previous by thread: Re: Importing/parsing CSV files
  • Next by thread: Re: Importing/parsing CSV files
  • Index(es):
    • Date
    • Thread