dbTalk Databases Forums  

Help Importing Excel in Script

comp.databases.filemaker comp.databases.filemaker


Discuss Help Importing Excel in Script in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
squeed2000@yahoo.com
 
Posts: n/a

Default Help Importing Excel in Script - 10-06-2005 , 01:02 PM






I have a script that calls for an import of an excel file stored on the
network drive. The file is called Daily_Log.xls. The file is updated
every morning before associates come to work. When the first person
logs into the system this script opens that file.

The file is always called Daily_Log.xls but the data is new every day.
For some reason the import always says that it can't find the file and
opens up a window and the user is having to click on the file which is
always there. But it seems that even though it is named exactly the
same, FMP7 thinks that it is different or missing.

How can I correct ?

-S


Reply With Quote
  #2  
Old   
opie
 
Posts: n/a

Default Re: Help Importing Excel in Script - 10-06-2005 , 04:56 PM






squeed2000 (AT) yahoo (DOT) com wrote:
Quote:
I have a script that calls for an import of an excel file stored on the
network drive. The file is called Daily_Log.xls. The file is updated
every morning before associates come to work. When the first person
logs into the system this script opens that file.

The file is always called Daily_Log.xls but the data is new every day.
For some reason the import always says that it can't find the file and
opens up a window and the user is having to click on the file which is
always there. But it seems that even though it is named exactly the
same, FMP7 thinks that it is different or missing.

How can I correct ?

-S

When you are in script maker and specifying the name of the file and the
path to it, is there a check box in the lower left corner of the dialog
box with the words "Save relative path only"? If you find this check
box, make sure it IS NOT CHECKED. This will tell FileMaker to use an
ABSOLUTE PATH to the file.


http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.