From: "成田恭一" <ntnarita_prn@...>
Date: 2015-07-03T15:53:08+09:00
Subject: [ruby-list:50198] Re: [質問] Win32OLE Excel ネットワーク上のファイルOpen失敗

$B@.ED$G$9!#(B

> anet_file = getAbsolutePath('\\\\A.B.C.D\yama\tmp\net.xlsx')
$B$G$O$J$/(B

> anet_file = getAbsolutePath('\\\\A.B.C.D\\yama\\tmp\\net.xlsx')

$B$@$H;W$$$^$9!#(B

[\]$B$r$"$i$o$9$?$a$K$O(B[\\]$B$H$7$J$$$HM=4|$7$?F0$-$K$J$j$^$;$s!#(B
[\\]$B$r$"$i$o$9$?$a$K$O(B[\\\\]$B$G$9!#(B

$B;d$N4D6-$G$d$C$F$_$?$i(BExcel$B$N%U%!%$%k$,3+$1$^$7$?$N$G!#(B

$B0J>e!"$43NG'$/$@$5$$!#(B

On 2015/07/02 14:43, YAMAGATA, Isao wrote:
> $B;3eQ$G$9!#(B
> 
>> ? $B%U%!%$%kL>$^$?$O%Q%9$,B8:_$7$^$;$s!#(B
>> ? $B%U%!%$%k$,B>$N%W%m%0%i%`$K$h$C$F;HMQ$5$l$F$$$^$9!#(B
>> ? $BJ]B8$7$h$&$H$7$F$$$k%V%C%/$HF1$8L>A0$N%V%C%/$,8=:_3+$+$l$F$$$^$9!#(B
>>      HRESULT error code:0x80020009
> 
> http://qiita.com/t_oginogin/items/ddbeaac0a7e407dfd3c4
> $B$3$3$G!"F1$88=>]$,>R2p$5$l$F$$$F2r7hJ}K!$b:\$C$F$$$^$9$,!"(B
> $B;29M$K$J$j$^$;$s$+$M!)(B
> 
> $B0J>e(B
> --------------------
> $B!:(B____________________________________________________________
> $B:9=P!'(B<yamataka@u08.itscom.net>
> $B08@h!'(BRuby users \\(Japanese\\) <ruby-list@ruby-lang.org>
>   
> $BF|IU!'(BThu, 02 Jul 2015 14:05:31 +0900
> $B7oL>!'(B[ruby-list:50193] Re: [$B<ALd(B] Win32OLE Excel $B%M%C%H%o!<%/>e$N%U%!%$%k(BOpen$B<:GT(B
> --------------------
> $B;38}$G$9!#(B
> 
>> $B@.ED$H?=$7$^$9!#(B
>>
>> \$B$O(B\\$B$H=q$+$J$1$l$P$J$i$J$$$N$G(B\\$B$H$$$&$N$O(B\\\\$B$H$J$k$H$$$&(B
>> $B;v$O$J$$$G$7$g$&$+!)(B
>>
>> $B$"$F$:$C$]$&$G?=$7Lu$"$j$^$;$s$,$43NG'$$$?$@$1$J$$$G$7$g$&$+!#(B
> 
> $B@.ED$5$s!"$465<($"$j$,$H$&$4$6$$$^$9!#(B
> 
> $BG0$N0Y!"4D6-$O!"(B
> CYGWIN_NT-6.2 JPC20156460 2.0.4(0.287/5/3) 2015-06-09 12:22 x86_64
> Cygwin
> ruby 2.2.2p95 (2015-04-13 revision 50295) [x86_64-cygwin]
> $B$G$9!#(B
> 
> #! /bin/ruby
> # coding: cp932
> 
> require 'win32ole'
> 
> def getAbsolutePath filename
>     fso = WIN32OLE.new('Scripting.FileSystemObject')
>     return fso.GetAbsolutePathName(filename)
> end
> 
> anet_file = getAbsolutePath('\\\\A.B.C.D\yama\tmp\net.xlsx')
> 
> excel  = WIN32OLE.new('Excel.Application')
> excel.visible = true
> 
> net_workbook   = excel.workbooks.open(anet_file)
> 
> $B$G!"(B\\\\A.B.C.D $B$N$h$&$K!";XDj$7$^$7$?$,!"(B
> 
> yama@JPC20156460:/cygdrive/c/Temp$ ./tako.rb
> ./tako.rb:16:in `method_missing': (in OLE method `open': ) (
> WIN32OLERuntimeError)
>      OLE error code:FFFFFFFF800A03EC in Microsoft Excel
>        $B%U%!%$%k(B '\\A.B.C.D\yama\tmp\net.xlsx' $B$K%"%/%;%9$G$-$^$;$s!#<!$N(B
> $B$$$:$l$+$NM}M3$,9M$($i$l$^$9!#(B
> 
> ? $B%U%!%$%kL>$^$?$O%Q%9$,B8:_$7$^$;$s!#(B
> ? $B%U%!%$%k$,B>$N%W%m%0%i%`$K$h$C$F;HMQ$5$l$F$$$^$9!#(B
> ? $BJ]B8$7$h$&$H$7$F$$$k%V%C%/$HF1$8L>A0$N%V%C%/$,8=:_3+$+$l$F$$$^$9!#(B
>      HRESULT error code:0x80020009
>        Exception occurred.
>          from ./tako.rb:16:in `<main>'
> 
> $B$NMM$K!"%(%i!<$K$J$C$F$7$^$$$^$9!#(B
> 
> $B",(B____________________________________________________________
> 
> 

-- 
$B!g!g!g!g!g!g!g!g!g!g!g!g!g!g!g!g!g!g!g!g!g!g!g(B
$B!!@.ED!!630l(B
      mail: ntnarita_prn@net-do.jp
$B!!3t<02q<R%M%C%H%o!<%/(B $B%=%U%H(B $B%"%=%7%(%$%D!!(B
$B!!!!!!(B $B3+(B $BH/(B $B<<(B  $B;%KZ;TCf1{6hKL#1>r@>#9CzL\#3!]#2#7Bh;08E5W:,%S%k(B8F
$B!!!!!!!!!!!!!!!!!!!!(B $B-d(B011-251-7211   fax011-251-7212
$B!!!!!!(B $BK\!!!!(B $B<R!!;%KZ;T@>6h@>D.Fn#1#7!]#2!]#4#0(B
$B!!!!!!!!!!!!!!!!!!!!(B $B-d(B011-661-6618$B!!(Bfax011-661-6931
                          hp: http://www.ntwork.co.jp
      $BEl5~;YE9!!El5~ETBfEl6hEl>eLn#3CzL\#3#9(B-$B#1#0(B $B8wOB%S%k#63,(B
$B!!!!!!!!!!!!!!!!!!!!(B $B-d(B03-6803-2489$B!!(Bfax03-6803-2396$B!!(B
$B!!!!!!(B
$B!!!!(B $B!H?GNE=jMQ(B $B7HBSM=Ls2DG=!&EE;R%+%k%F(BAmbitious$B!I(B
$B!g!g!g!g!g!g!g(B Network Soft Associates Inc. $B!g!g!g!g!g!g(B