🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Thread View: fj.lang.visualbasic
1 messages
1 total messages Started by tt76504 Wed, 01 Apr 1998 00:00
[Q] VB$B$+$i(BExcel$B$GD"I<=PNO(B
#208
Author: tt76504
Date: Wed, 01 Apr 1998 00:00
46 lines
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
------------------------------------------------------
Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads