macOS AppleScript for Excel (Save file as tab delimited text)

[mac-user27]

Hey guys,

I am new to AppleScript and need some help!
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!

 

[mac-user27]

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.