Article View: fj.lang.visualbasic
Article #208[Q] VB$B$+$i(BExcel$B$GD"I<=PNO(B
From: tt76504
Date: Wed, 01 Apr 1998 00:00
Date: Wed, 01 Apr 1998 00:00
46 lines
1929 bytes
1929 bytes
$B$O$8$a$^$7$F!"BgDM$H?=$7$^$9!#(B
VB5$B$+$i(BExcel97$B$r5/F0$7$F(BExccel$B$O$=$N$^$^$G!"?F$G$"$k(BVB$B$N(B
$B%W%m%0%i%`$r=*N;$5$;$k$K$O$I$&$9$l$P$h$$$N$G$7$g$&$+!)(B
$B6qBNE*$K$O!"(B
Private AppXl as object
Private BookXl as object
Private WsXl as object
Sub Command1_Click()
set AppXl = CreatObject("Excel.Application")
set BookXl = AppXl.workbooks.add
set WsXl = AppXl.activesheet
AppXl.visible = True
'$BMe@~$NIA2h(B
'$B=q<0$N@_Dj(B
'$B%G!<%?$NF~NO(B
' Excel$B$O5/F0$7$?$^$^!*(B
set WsXl = Nothing
set BookXl = Nothing
set AppXl = Nothing
end sub
$B$N$h$&$K$7$F$$$k$N$G$9$,!"(BExcel$B$N(Bbook$B$rJD$8$h$&$H$9$k$H(B
$B%Z!<%80cH?$N%(%i!<$,=P$^$9!#!J(BExcel$B<+BN$N=*N;$OLdBj$"$j(B
$B$^$;$s!#!K(B
$B%*%V%8%'%/%H$N2rJ|$r9T$J$o$J$1$l$P(Bbook$B$rJD$8$F$b%(%i!<(B
$B$O=P$^$;$s$,!"(BExcel$B$h$jA0$K?F$G$"$k(BVB$B$N%W%m%0%i%`$,=*N;(B
$B$9$k$3$H$b$"$k$N$G!"(Bunload$B;~$K%*%V%8%'%/%H$r2rJ|$9$k$H(B
$B$$$C$?$3$H$b$G$-$^$;$s!#(B
FAQ$B$+$b$7$l$^$;$s$,$h$m$7$/$*4j$$$7$^$9!#(B
$B$^$?!"(BVB$B$+$i30It%W%m%0%i%`$r5/F0$9$k:]$N:nK!$J$I$b(B
$B%"%I%P%$%9$7$F$$$?$@$1$k$H4r$7$$$G$9!#(B
------------------------------------------------------
Department of applied physics, university of Tokyo
Yuichi OTSUKA ($BBgDM(B $BM:0l(B)
e-mail: otsuka@pothos.t.u-tokyo.ac.jp
------------------------------------------------------
Technical Details
Message-ID:
<kf6u38d6402.fsf@ecc-as03.hongo.ecc.u-tokyo.ac.jp>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: Japanese,JIS X-Google-Thread: 105c2e,cccfd785740ad484,start X-Google-Attributes: gid105c2e,public From: tt76504 <tt76504@hongo.ecc.u-tokyo.ac.jp> Subject: [Q] VB$B$+$i(BExcel$B$GD"I<=PNO(B Date: 1998/04/01 Message-ID: <kf6u38d6402.fsf@ecc-as03.hongo.ecc.u-tokyo.ac.jp> X-Deja-AN: 339835202 Sender: tt76504@ecc-as03.hongo.ecc.u-tokyo.ac.jp Organization: "University of Tokyo (ECC-Hongo)" NNTP-Posting-User: tt76504 Newsgroups: fj.lang.visualbasic