exporting to excel

[endposse10]

is it possible to create a script that will export data to excel, AND automatically open it after it has been exported?

currently i have a script that will export data from the fields into a comma seperated file. what i'm stuck on is getting filemaker to open up that file with excel. is that possible? thanks

[DanBrill]

hey,

Try the SendMessage script step. You can specify a file to open or to print.

Dan

[Sabrina]

That's a wonderful solution for a windows computer, but what about we poor Mac users? SendMessage returns an error message when used on a Mac.

[cjaeger]

there is a corresponding script step which does just the same,

send apple event

of course, you will have to check for the platform first

if(abs(status(currentplatform)=1, -- MacOS (-1 = OS X, 1=MacOS)

send appleevent [odoc, export.txt,MSExcel]

else

send message[odoc, export.txt,MSExcel]

endif

[Sabrina]

Cjaeger,

Thanks! I haven't played around with that before and it's pretty useful! Thanks for bringing my attention to it!

Sabrina

[endposse10]

thanks guys! that was a lot easier than i though it would be... i'm liking filemaker more and more!