Ok I have created a page to select the month and the year of the data you are requesting. I have 2 drop down lists one for the month and one for the year. I went into scriptmaker and wrote what I thought would work for a script to navigate to the desired page per what you choose on the month pop up list.

Here is what I did in script maker

if month = "january"

preform script [sub-scripts, External"billing1.fp5"]

end if

if month = "february"

preform script [sub-scripts, External"billing2.fp5"]

end if

if month = "March"

preform script [sub-scripts, External"billing3.fp5"]

end if

if month = "April"

preform script [sub-scripts, External"billing4.fp5"]

end if

if month = "May"

preform script [sub-scripts, External"billing5.fp5"]

end if

if month = "june"

preform script [sub-scripts, External"billing6.fp5"]

end if

if month = "july"

preform script [sub-scripts, External"billing7.fp5"]

end if

if month = "August"

preform script [sub-scripts, External"billing8.fp5"]

end if

if month = "september"

preform script [sub-scripts, External"billing9.fp5"]

end if

if month = "October"

preform script [sub-scripts, External"billing10.fp5"]

end if

if month = "November"

preform script [sub-scripts, External"billing11.fp5"]

end if

if month = "December"

preform script [sub-scripts, External"billing12.fp5"]

end if

I Thought this would allow me to choose the month from the Drop Down List, But it did not work. How should I write this script when I want it to choose between 12 choices.

Thanks in advance mentairia Bulveridge

Excuse me if I am misinterpreting your problem but you have to run the script by either selecting it from the Script menu or by using a button that will perform the script. Attached is an example, FMP version 4, that works for Jan, Feb & Mar.

Month.zip

I do have it linked to a button called get billing sheet but the script only returns january no other month works.

Does nothing happen if you choose a month other than January or do all months return January? Any chance you can post a sample of your files?

Nothing Happens if I choose any other month!

Here is the files

Hereissample.zip

In your Goto MonthName script from each billing file add the Select Window script step after Go To Layout. Hopefully this step is available in FM6.

Your GoTo Selected Month script in Billing1 was empty when I converted the file to FM7 but I am assuming it calls your other GoTo ThisMonth scripts in that file.

No (select window) any other Ideas?

Looks like you are using the equivalent of Select Window already but in the Billing1 Scripts rather than in the GoTo Febuary (you forgot the R after the : script in the billing2 file.

It is working to get the window but does not make it the active window. I know about the february just sent you a sample.

Wish I could help but I jumped from version 4 to 7, not sure how it works in 6. You might try the version 5 - 6 forum here, hopefully someone there can get you on your way.