Open Excel from Filemaker script

[Per Lind]

Hi All!

I have a script importing currency into Filemaker.

Today I do as follow:
1. Startet the script which open an URL to my bank currency webpage.

2. I have manually open Excel file: C:\EXCEL kalkyler\0 Valuta 1.xlsx

3. I go to the open webpage and CTRL+A and CTRL+C

4. I go to the open Excel and past CTRL+V

5. Then the script continue import the Excel page into Filemaker.

6. Ready to use the new currency in my Filemaker apps.

Question:

Is it any possibility to let Filemaker open Excel automaticly
or by a plugin or?

Thankss in advance
-Per

[Wim Decorte]

Sounds like you are after exchange rates?  If so then look for a web service / API that offers them and integrate with those.

Alternatively, open that URL in a web viewer, wait for the page to load (look for the closing HTML tag) and grab the web site's content in a variable and parse through that.  That would skip Excel altogether.

But I would look for a good API instead of this.  Your own bank may have one for this info...