Applescript for getting data from a spreadsheet

Bob Sneidar bobs at twft.com
Fri Dec 9 20:15:02 EST 2011


Hey! That did the trick! Now how would anyone know that? Let's say I was the first person ever to begin working with Applescript. How would I have ever come up with that solution? But thank you. Now I can get on with my uber utility. 

Bob


On Dec 9, 2011, at 4:35 PM, zryip theSlug wrote:

> On Sat, Dec 10, 2011 at 1:03 AM, Bob Sneidar <bobs at twft.com> wrote:
>>> 8-)
>>> 
>>> The Excel documentation has numerous traps. Sometimes the syntax is
>>> natural and sometimes... surnatural. ;-)
>>> 
>>> Try:
>>> open workbook workbook file name "DHCP Clients.xlsx"
>>> 
>>> 
>>> Best regards,
>>> --
>>> -Zryip TheSlug- wish you the best! 8)
>>> http://www.aslugontheroad.com
>> 
>> I get: error "Microsoft Excel got an error: Can’t continue open workbook." number -1708
>> 
>> By the way I know the path is correct.
>> 
>> I tried with the full path:
>> open workbook workbook file name "/Volumes/data/LogosAdmin/TechData/Tech Documents/DHCP Clients.xlsx"
>> 
>> I tried the short name:
>> open workbook workbook file name"DHCP Clients.xlsx"
>> 
>> I tried setting the default path:
>> set default file path to "/Volumes/data/LogosAdmin/TechData/Tech Documents/"
>> open workbook workbook file name "DHCP Clients.xlsx"
> 
> The problem should be in the unix path.
> 
> Try:
> set myPath to POSIX file "/Volumes/data/LogosAdmin/TechData/Tech
> Documents/DHCP Clients.xlsx"
> open workbook workbook file name myPath
> 
> 
> Best regards,
> -- 
> -Zryip TheSlug- wish you the best! 8)
> http://www.aslugontheroad.co.cc
> 
> _______________________________________________
> 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