Article View: fj.lang.visualbasic
Article #1309Re: VB4 で EXCEL 形式で保存したい。
From: Sato Masahiro
Date: Mon, 29 Sep 1997 00:00
Date: Mon, 29 Sep 1997 00:00
33 lines
1421 bytes
1421 bytes
In article <01bccbd6$9240ee60$8f26ca9e@ws4657.ho.furukawa.co.jp>, tanabe@nikko.furukawa.co.jp says...
>
>$B#V#B#4$G:N<h$7$?%G!<%?$r(Bexcel$B7A<0$GJ]B8$7$?$$$N$G$9$,!"$J$K$+$&$^$$L?Na$O(B
$BNc(B: Excel $B7A<0$N%U%!%$%k$r:n@.(B
'$BCm(B: Excel $B%*%V%8%'%/%H%i%$%V%i%j$r;2>H@_Dj$9$k$3$H(B
Dim Xl As Object
Dim Bk As Object
Set Xl = CreateObject("Excel.Application")
Set Bk = Xl.Workbooks.Add(xlWorksheet)
With Bk.Worksheets(1)
.Cells(1, 1).Value = "aaa"
.Cells(2, 1).Value = "bbb"
.SaveAs "\doc\ABC.xls"
End With
Xl.Quit
$B0J>e$NJ}K!$G$O!"$I$&$G$7$g$&$+!#(BExcel Basic $B$O>\$7$/$J$$$N$G$9$,(B
$B>e5-$N$h$&$J;v$r9T$($P!"(B*.xls $B7A<0$GJ]B8$,$G$-$k$H;W$$$^$9!#(B
$B$?$@!"$b$7%+%s%^7A<0$N(B CSV $B%U%!%$%k$r:n@.$9$k=hM}$,$"$k$J$i$P(B
1. *.csv $B%U%!%$%k$r3+$/(B
2. *.xls $B7A<0$GJ]B8(B
$B$H$$$&=hM}$rDI2C$9$k$N$,NI$$$H;W$$$^$9!#(B
--
$B:4F#@59((B <masahiro@cij.co.jp>
Technical Details
Message-ID:
<60n6h3$c7v@cij-gw.ykhm.cij.co.jp>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<01bccbd6$9240ee60$8f26ca9e@ws4657.ho.furukawa.co.jp>Show Full Headers
Complete Article Headers
X-Google-Language: Japanese,JIS X-Google-Thread: 105c2e,9abc3aaf3845a3d7 X-Google-Attributes: gid105c2e,public From: masahiro@cij.co.jp (Sato Masahiro) Subject: Re: VB4 で EXCEL 形式で保存したい。 Date: 1997/09/29 Message-ID: <60n6h3$c7v@cij-gw.ykhm.cij.co.jp> X-Deja-AN: 276564157 References: <01bccbd6$9240ee60$8f26ca9e@ws4657.ho.furukawa.co.jp> Organization: CIJ Newsgroups: fj.lang.visualbasic