I edited this because I realized that I had an extra / in my file path.
I get my script to run just fine and have the exported Excel file go into the same folder as the FMP File, but what I want it to do is go to a relative path above the containing folder. I can't use a fixed file path because each client has their own FMP database, which is filed about 50 different ways.
currently I have: File:/Site Survey/Lables.xlsx
First, I have been getting this error. I tried changing the name and deleting the existing file, but that doesn't help.
Ideally I would like the script to work up the folders----> meaning it would save in "Site Survey"in a perfect world, it would go backwards until it found "Survey"and thenin a subfolder called "Beginner".
I know just enough about file paths to get into trouble.