🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: fj.lang.visualbasic
Article #1309

Re: VB4 で EXCEL 形式で保存したい。

#1309
From: Sato Masahiro
Date: Mon, 29 Sep 1997 00:00
33 lines
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-mail
References: <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