Apple

On Sep 11, 2008, at 5:13 PM, Olof Hellman wrote:

My first instinct is to ask what the difference is between the files before and after resaving with Excel.

My second instinct is to suggest that you insert this

                tell app “Microsoft Excel”
                        open <the file in question>
                        save document 1 with replacing
                end tell

into the workflow.

- Olof Hellman
   Microsoft MacBU

From: applescript-users-bounces+olofh=email@hidden [mailto:applescript-users-bounces+olofh=email@hidden] On Behalf Of David Wolfe
Sent: Thursday, September 11, 2008 9:36 AM
To: Oakley Masten
Cc: Users Group AppleScript
Subject: Re: Excel issues

Not a solution and, again, not Applescript related, but maybe the information will help someone point you in the right direction.

We have a very similar problem with inData imports of tab-delimited text files into InDesign. inData will not recognize and import the files unless they are first opened and saved in Excel.

Good luck,
David

On Sep 11, 2008, at 12:17 PM, Oakley Masten wrote:

Hi All

I know this is not the right place to ask but I am hoping someone can direct me to that place.

We are using AppleScripts to run lots of processes and have run into a glitch.
It is not stopping the process but is just annoying.

We have a sql database on a Windows 2003 server [ I don't know the versions but can find out if it would help] that creates a report for these processes.
This report is an Excel doc.
[side bar - this file does not have a "file type" or a "creator type" in it.
Adding the "file type" and "creator type" via AppleScript does not fix the problem.]

the report gets imported into a FileMaker 9 database which is used to drive several scripted processes.

Now for the glitch.
The FileMaker dBase will not import the Excel data unless it is first opened in Excel, on my Mac running OSX 10.4.11, and then re-saved. [Opening and saving the file using a Windows machine does not fix the problem.]

Then it imports just fine.

An obvious answer might be to use ODBC you say.
I have already said this and was informed that the Mac side would not be allowed to directly interface with the "real computers" on the dark side. I jest, but that was the response with some liberal translation added.

Has anyone had similar issues and if so where do I look to fix this?

Thanks in advance for any insight here

Oakley

class="apple-converted-space"> http://lists.apple.com/archives/applescript-users

This email sent to email@hidden