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