Newbies endposse10 Posted June 17, 2003 Newbies Share Posted June 17, 2003 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 Link to comment Share on other sites More sharing options...
DanBrill Posted June 17, 2003 Share Posted June 17, 2003 hey, Try the SendMessage script step. You can specify a file to open or to print. Dan Link to comment Share on other sites More sharing options...
Sabrina Posted June 17, 2003 Share Posted June 17, 2003 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. Link to comment Share on other sites More sharing options...
cjaeger Posted June 17, 2003 Share Posted June 17, 2003 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 Link to comment Share on other sites More sharing options...
Sabrina Posted June 17, 2003 Share Posted June 17, 2003 Cjaeger, Thanks! I haven't played around with that before and it's pretty useful! Thanks for bringing my attention to it! Sabrina Link to comment Share on other sites More sharing options...
Newbies endposse10 Posted June 17, 2003 Author Newbies Share Posted June 17, 2003 thanks guys! that was a lot easier than i though it would be... i'm liking filemaker more and more! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7613 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now