Problems Opening an EXCEL text file

Bob Sneidar bobs at twft.com
Fri Jan 7 11:29:10 EST 2011


Sounds like a refresh issue. 

Bob


On Jan 7, 2011, at 4:10 AM, Ian McKnight wrote:

> A click on the target field made the list appear as it should! While my
> table only contains 90 lines of 3 items I'm at a loss to explain this.
> However, it is working as it should.
> 
> Thanks
> 
> On 7 January 2011 10:46, Ian McKnight <iangmcknight at gmail.com> wrote:
> 
>> Hi
>> 
>> I have a table of data held in a table in EXCEL and I want to import it
>> into a field in a LC stack.
>> I saved the file from EXECL as a tab delimited text file
>> and used the following handler
>> 
>> *
>> 
>> on
>> *mouseUp
>> 
>> *answer* file "choose" with *type* "text|txt|TXT"
>> 
>> *if* it is empty or it is *cancel* *then* *exit* mouseup
>> 
>> *put* "file:"&it into fName
>> 
>> *put* URL fName into fld "display"
>> *
>> 
>> end
>> *mouseUp
>> The stange thing is that this doesnt appear to work - I get a blank field.
>> However if I open and save the text file in NotePad or WordPad and then run
>> the handler I get the data displayed in the field correctly.
>> 
>> So how do I get the text file to be recognised without putting it through
>> Notepad? What does EXCEL do to the file that NotePad doesn't? I'm using LC
>> 4.5.1 and have also tested this on Rev Enterprise 4.0 both on Windows (Win 7
>> and XP)
>> 
>> --
>> Regards
>> 
>> 
>> Ian McKnight
>> 
>> iangmcknight at gmail.com
>> =======================
>> 
> 
> 
> 
> -- 
> Regards
> 
> 
> Ian McKnight
> 
> iangmcknight at gmail.com
> =======================
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode





More information about the Use-livecode mailing list