Importing from Excel-Having issue with the Name Range

[Nestor]

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

[comment]

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

[Nestor]

how do i do this.

[Nestor]

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

[comment]

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.

[Kingme]

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, 2008 by Guest