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

$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

$B0J>e$G$9!#(B

On 2015/07/02 13:48, yamataka@u08.itscom.net wrote:
> 
> 
> $B;38}$G$9!#(B
> 
>> $B$?$7$+!"2<5-$N(Bcygwin$BMQ$N@dBP(Bpath$B$N<hF@$rF~$l$k$H$&$^$/$$$/$+$b$7$l$J$$(B
> $B$G$9!#(B
>> http://magazine.rubyist.net/?0004-Win32OLE
>> $B$3$NJU$j$N%3!<%I$G$9!#(B
>> fso = WIN32OLE.new('Scripting.FileSystemObject')
>> net_file = fso.GetAbsolutePathName('\\roswell\share_data\net.xlsx')
> 
> $B$465<($"$j$,$H$&$4$6$$$^$9!#(B
> 
> #! /bin/ruby
> # coding: cp932
> 
> require 'win32ole'
> 
> def getAbsolutePath filename
>     fso = WIN32OLE.new('Scripting.FileSystemObject')
>     return fso.GetAbsolutePathName(filename)
> end
> 
> alocal_file= getAbsolutePath('C:\Temp\local.xlsx')
> anet_file = getAbsolutePath('\\A.B.C.D\yama\tmp\net.xlsx')
> 
> excel  = WIN32OLE.new('Excel.Application')
> excel.visible = true
> 
> local_workbook = excel.workbooks.open(alocal_file)
> net_workbook   = excel.workbooks.open(anet_file)
> 
> $B$G!";n$7$F$_$^$7$?$,!"(B
> 
> anet_file = getAbsolutePath('\\A.B.C.D\yama\tmp\net.xlsx')  $B$G$O!"(B
> 
>   'C:\A.B.C.D\yama\tmp\net.xlsx' $B$,8+$D$+$j$^$;$s(B
> $B$HI=<($5$l!"(Bnetwork$B>e$N%U%!%$%k$,!"%m!<%+%k%U%!%$%k$H$7$F<h$j07$o$l$F$$(B
> $B$k%(%i!<%a%C%;!<%8$,I=<($5$l$^$9!#(B
> 
> anet_file = getAbsolutePath('//A.B.C.D/yama/tmp/net.xlsx')
> $B$G$O!"(B# \\A.B.C.D\yama\tmp\net.xlsx' $B$K%"%/%;%9$G$-$^$;$s(B
> 
> $B$HI=<($5$l!"(BGetAbsolutePathName $B$rMQ$$$F$b!";DG0$J$,$i2r7h$K;j$j$^$;$s$G(B
> $B$7$?!#(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