Sounds like there's an error in your script. You'll need to post that script so we can see more detail.
To post a script to the forum:
- You can upload a screen shot of your script
- You can print a script to a PDF, open the PDF and then select and copy the script as text from the opened PDF.
- If You have FileMaker advanced, you can generate a database design report and copy the script as text from there.
- If you paste a text form of the script, you can use the Script Pretty box in the Known Bugs List database to paste a version that is single spaced and indented for a more professional look to your script. (Use the HTML option and paste the text into the HTML editor.)
it is very simple script, just testing the whole excel thing.
"Save Records as Excel [Restore; "projectTrack_monthlySummary.xls"; Current record]
That's the only line? there's no set error capture [on] step?
Is this from a system running Lion (Mac OS 10.7)?
If so, it should be to a file with the suffix .xslx instead of .xls
have added error capture I just wanted to see if it worked, so sorry for the briefness.
I have changed it to .xlsx
see below. Same error
How did you create the file refrence shown? Did you type it in or click the Add File Button and use that dialog to create it?
I'm wondering if that entire file reference is a valid file path...
What version of FileMaker Pro are you using? Versions prior to 11.0v4 will not export to Excel under Lion.
I had copied and pasted the file path. This was my mistake, when I browsed to the file it worked fine. Thanks for that.
Jade I was using Version 11 v4
Thanks for the help