Applescript for getting data from a spreadsheet

zryip theSlug zryip.theslug at gmail.com
Fri Dec 9 18:35:48 CST 2011


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



More information about the use-livecode mailing list