Welcome to the MacNN Forums.

mjpaci · Apr 18, 2001, 07:08 PM

Here is the deal:
We have a script that runs in VBA under Excel right now. It takes an Excel spreadsheet and saves it as a tab-delimited text file. Great. It works. However, ever since the Excel Y2K update came out, any time you save a document using VBA it gives you 4 digits years. I can do a 'Save As...' command in the Application and get the two digit year, but not with VBA.

Since all this script does is open the file save it in a different format and then save it somewhere else, I figured I could do it with AppleScript.

Here is what I have so far:

Code:
tell Application "Microsoft Excel"
  Activate
  Open "Macintosh HD  esktop Folder:Project:Input:File A"
  --Missing Stuff
  -- I want to save it to a different location as a tab delim text file but cannot figure out for the life of me the correct syntax
end tell

Any help would be greatly appreciated.

--mike

[This message has been edited by mjpaci (edited 04-18-2001).]

[This message has been edited by mjpaci (edited 04-19-2001).]