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

hey,

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

Dan

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.

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

Cjaeger,

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

Sabrina

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