AppleScript for Excel (Save file as tab delimited text)

Discussion in 'Mac Programming' started by mac-user27, Jan 7, 2010.

  1. mac-user27 macrumors newbie

    Joined:
    Jan 7, 2010
    #1
    Hey guys,

    I am new to AppleScript and need some help! :confused::rolleyes::)
    I am trying to automated file saving process in Excel from .xls to .txt (tab delimited format).
    Can someone help me with the script? please!

    here is what I have... and it does not work... :(

    tell application "Excel"
    save active workbook as text Mac file format
    end tell

    thanks!
     
  2. mac-user27 thread starter macrumors newbie

    Joined:
    Jan 7, 2010
    #2
    More details about what I am trying to do with script and excel files

    I need help to create a script that would do the following:

    Save all open workbooks as tab delimited text file

    steps program should take:
    1.save active workbook as tab delimited text file
    2.close
    3.activate next workbook
    1.save as tab delimited text file
    2.
    3.
    1..... end when all closed.

    :apple:
     

Share This Page