Im trying to create a script that will import a certain file everyweek. My problem is that everyweek my file has a different Name Range.

The namerange in an excel sheet is on the bottom left of the screen. So im trying to figure out a way to tell filemaker to disregard the name range when importing a certain file. is there a way to do this? what else can i do?

Thanks

Using a named range is optional. You can choose to import the entire worksheet instead.

how do i do this.

My issue is that every week my worksheet has a different name. the source is still the same, but the worksheet name is different. so when i try to set up a script it errors out because the worksheet specified in my script does not match the one that im trying to import.

any way around this?

See Jpeg

Worksheet.zip

If your Import Records script step is NOT set to 'Perform without dialog', you should get a dialog allowing you to select the worksheet at script runtime.

I have an addition question about this: is there a way to script the name of the worksheet, if the source file is a variable?

Import Records[source: $filetoimport; Worksheet: "Worksheet"]

UPDATE: Just read this somewhere else:

"Import File script step uses variables to specify the path and file names to the Excel file. As a result, FMP does NOT ask for the specific worksheet you wish to import from when you are creating the script step. I had to add a second explicit path to a real spreadsheet with a bogus name in order to select the specific worksheet I wanted. I then deleted the bogus spreadsheet so now my script uses the variable path/filename AND grabs the right worksheet. Hardly elegant but it seems to work. FileMaker needs to add a directly accessible option to enter in specific worksheet or range names for this script step. Let me know if anyone has any better methods."

Edited October 25, 200817 yr by Guest