µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excelµ{¦¡°Ï
» §ì¨ú¥t¤@ÓexcelÀɸê®Æ
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
§ì¨ú¥t¤@ÓexcelÀɸê®Æ
imzues
µoµu®ø®§
¥[¬°¦n¤Í
imzues
·í«eÂ÷½u
UID
924
©«¤l
72
¥DÃD
24
ºëµØ
0
¿n¤À
172
ª÷¿ú
172
ÂI¦W
0
§@·~¨t²Î
xp
³nÅ骩¥»
office 2003
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
90 ¤p®É
µù¥U®É¶¡
2010-7-16
³Ì«áµn¿ý
2023-7-6
¤¤¾Ç¥Í
©«¤l
72
¥DÃD
24
ºëµØ
0
¿n¤À
172
ÂI¦W
0
§@·~¨t²Î
xp
³nÅ骩¥»
office 2003
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2010-7-16
³Ì«áµn¿ý
2023-7-6
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2011-3-28 13:22
|
¥u¬Ý¸Ó§@ªÌ
§ì¨ú¥t¤@ÓexcelÀɸê®Æ
½Ð°Ý¤@¤U¡A
§Ú·Q§ì°_©T©w¸ô®|¤UªºexcelÀɮתº¸ê®Æ
§Ún«ç»ò¥Î¥¨¶°¼g
«ô°U¦U¦ì¤j¤j«üÂI¤@¤U
¼Ó¥D¼ö©«
½Ð°Ý±N¤£¦PÀɮ׶פJ¤À¶ªºµ{¦¡
¥Îvba»yªk¤ñ¹ï¤é´Á
¦³ÓÀx¦s®æ¤ë¾äªº°ÝÃD
§R°£Àx¦s®æ¸ÌALT+ENTER©Ò³y¦¨ªº´«¦æ!!
¨Ì©Ò¹º¤Àªº®É¶¡§ì¸ê®Æ¥[Á`
¼Ï¯Ã¤ÀªRªº°ÝÃD
¦³Ãö±N¸ê®Æ¤£«ÂжK¤Wªº°ÝÃD!!!
¦³Ãösheet¦WºÙªº°ÝÃD
½Ð±Ð¤@¤UEXCEL¥Õ©³ªº°ÝÃD
°ÊºA¹Ïªí°ÝÃD
¦¬ÂÃ
¤À¨É
GBKEE
µoµu®ø®§
¥[¬°¦n¤Í
GBKEE
·í«eÂ÷½u
UID
16
©«¤l
5923
¥DÃD
13
ºëµØ
1
¿n¤À
5986
ª÷¿ú
5986
ÂI¦W
0
§@·~¨t²Î
win10
³nÅ骩¥»
Office 2010
¾\ŪÅv
150
©Ê§O
¨k
¨Ó¦Û
¥xÆW°ò¶©
¦b½u®É¶¡
4811 ¤p®É
µù¥U®É¶¡
2010-5-1
³Ì«áµn¿ý
2022-1-23
¶W¯Åª©¥D
©«¤l
5923
¥DÃD
13
ºëµØ
1
¿n¤À
5986
ÂI¦W
0
§@·~¨t²Î
win10
³nÅ骩¥»
Office 2010
¾\ŪÅv
150
©Ê§O
¨k
¨Ó¦Û
¥xÆW°ò¶©
µù¥U®É¶¡
2010-5-1
³Ì«áµn¿ý
2022-1-23
2
#
µoªí©ó 2011-3-28 13:38
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
1#
imzues
Sub Ex()
Dim MySheet As Worksheet
Set MySheet = ActiveSheet
With Workbooks.Open("d:\test\¥~³¡¸ê®Æ.xls")
.Sheets(1).Range("a1:a10").Copy MySheet.Range("a1")
.Close 0
End With
End Sub
½Æ»s¥N½X
TOP
chin15
µoµu®ø®§
¥[¬°¦n¤Í
chin15
·í«eÂ÷½u
UID
3937
©«¤l
227
¥DÃD
3
ºëµØ
1
¿n¤À
273
ª÷¿ú
273
ÂI¦W
0
§@·~¨t²Î
XP
³nÅ骩¥»
XP
¾\ŪÅv
20
©Ê§O
¤k
¦b½u®É¶¡
30 ¤p®É
µù¥U®É¶¡
2011-3-22
³Ì«áµn¿ý
2013-1-29
¤¤¾Ç¥Í
©«¤l
227
¥DÃD
3
ºëµØ
1
¿n¤À
273
ÂI¦W
0
§@·~¨t²Î
XP
³nÅ骩¥»
XP
¾\ŪÅv
20
©Ê§O
¤k
µù¥U®É¶¡
2011-3-22
³Ì«áµn¿ý
2013-1-29
3
#
µoªí©ó 2011-3-28 13:55
|
¥u¬Ý¸Ó§@ªÌ
³oÃþ¾Þ§@Ó¤H¸û¶É¦V©óADO+SQL
Sub test()
Dim CNN As New ADODB.Connection
Dim RST As New ADODB.Recordset
With CNN
.ConnectionString = "provider=microsoft.jet.oledb.4.0;" & _
"extended properties='Excel 8.0;hdr=no';" & _
"data source=D:\¥~³¡¸ê®Æ.xls"
.Open
End With
[A1].CopyFromRecordset CNN.Execute("select * from [SHEET1$A1:A10]")
End Sub
©ÎªÌª½±µ¥Î¸ê®Æ~¶×¤J¥~³¡¸ê®Æ¡A¤â¤u¬d¸ß¡I
TOP
¦Ñ®L
µoµu®ø®§
¥[¬°¦n¤Í
¦Ñ®L
·í«eÂ÷½u
UID
6
©«¤l
109
¥DÃD
22
ºëµØ
0
¿n¤À
134
ª÷¿ú
134
ÂI¦W
0
§@·~¨t²Î
Win7
³nÅ骩¥»
Office 2000
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
¥x¥_¥«
¦b½u®É¶¡
529 ¤p®É
µù¥U®É¶¡
2010-5-1
³Ì«áµn¿ý
2023-3-5
¤¤¾Ç¥Í
©«¤l
109
¥DÃD
22
ºëµØ
0
¿n¤À
134
ÂI¦W
0
§@·~¨t²Î
Win7
³nÅ骩¥»
Office 2000
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
¥x¥_¥«
µù¥U®É¶¡
2010-5-1
³Ì«áµn¿ý
2023-3-5
4
#
µoªí©ó 2011-3-28 20:48
|
¥u¬Ý¸Ó§@ªÌ
¥»©«³Ì«á¥Ñ ¦Ñ®L ©ó 2011-3-29 12:12 ½s¿è
³Ì²³æ©ö¥Îªº¤èªk:ª«¥ó³sµ²ªk
¤E¤j¥\¯àªí
´¡¤J>>ª«¥ó>>¦ÛÀɮפ¤«Ø¥ß>>¤Ä¿ï³sµ²>>§äURL>>½T©w
TOP
imzues
µoµu®ø®§
¥[¬°¦n¤Í
imzues
·í«eÂ÷½u
UID
924
©«¤l
72
¥DÃD
24
ºëµØ
0
¿n¤À
172
ª÷¿ú
172
ÂI¦W
0
§@·~¨t²Î
xp
³nÅ骩¥»
office 2003
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
90 ¤p®É
µù¥U®É¶¡
2010-7-16
³Ì«áµn¿ý
2023-7-6
¤¤¾Ç¥Í
©«¤l
72
¥DÃD
24
ºëµØ
0
¿n¤À
172
ÂI¦W
0
§@·~¨t²Î
xp
³nÅ骩¥»
office 2003
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2010-7-16
³Ì«áµn¿ý
2023-7-6
5
#
µoªí©ó 2011-3-29 07:30
|
¥u¬Ý¸Ó§@ªÌ
·PÁ¦U¦ì¤j¤jªº¦^ÂСA°ÝÃD¤w¸g¸Ñ¨M¤F Á°Õ
TOP
7777
µoµu®ø®§
¥[¬°¦n¤Í
7777
·í«eÂ÷½u
UID
1520
©«¤l
125
¥DÃD
33
ºëµØ
0
¿n¤À
223
ª÷¿ú
223
ÂI¦W
0
§@·~¨t²Î
XP
³nÅ骩¥»
Excel 2003
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
¥x¥_¥«
¦b½u®É¶¡
344 ¤p®É
µù¥U®É¶¡
2010-9-6
³Ì«áµn¿ý
2024-6-8
¤¤¾Ç¥Í
©«¤l
125
¥DÃD
33
ºëµØ
0
¿n¤À
223
ÂI¦W
0
§@·~¨t²Î
XP
³nÅ骩¥»
Excel 2003
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
¥x¥_¥«
µù¥U®É¶¡
2010-9-6
³Ì«áµn¿ý
2024-6-8
6
#
µoªí©ó 2013-3-17 18:00
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
2#
GBKEE
·Ð½Ð¤j¤j ½Ð¦A¦¸¨ó§U
§ì¨ú¥t¤@ÓexcelÀɦp
ÀɦW¦³©ÒÅÜ°Ê
®É¡A
¤Î¤£¦P¤u§@ªí¸ê®Æ®É¡AÀ³ ¦p¦ó³B²z¡C
Sub ÂàÀÉ1()¡@
'ì¤è®×
Windows("³øªí1.xls").Activate
Range("A2:E24").Select
Selection.Copy
Windows("
³øªí2.xls
").Activate
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("A1").Select
End Sub
Sub ÂàÀÉ2()
'קï¤è®×
[G2] = InputBox(" ½Ð¿é¤J # ÀɦW #", " ÂàÀÉ¡G ¤µ¤é³øªí") '¤âÁä
22
Windows("³øªí1.xls").Activate
'ì©lÀɦW
Range("A2:E24").Select
Selection.Copy
Windows(
"³øªí" & [G2] & ".xls"
).Activate
'¹w ½Æ»sÀÉ®× ¤§ ÀɦW¥i§_¬° [ÅܼÆ] =G2 Àx¦s®æ¤§¤º®e
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("A1").Select
End Sub
«ô°U ¤j¤j«üÂI¤@¤U ·PÁÂ!!
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
TOP
ÀR«ä¦Û¦b :
¹D¼w¬O´£ª@¦Û§Úªº©ú¿O¡A¤£¸Ó¬O¨þ¥¸§O¤HªºÃ@¤l¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·