excel¶}±Òword¶ñ¤J¬ÛÃö¸ê®Æ
- ©«¤l
- 52
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 119
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-6
- ³Ì«áµn¿ý
- 2022-6-7
|
excel¶}±Òword¶ñ¤J¬ÛÃö¸ê®Æ
½Ð¦U¦ì¥ý¶iÀ°¦£¥Îvba¥Îexcel¶}±Òword¶ñ¤J¬ÛÃö¸ê®Æ¥i¥H°µ¨ì¶Ü
?½Ð°Ñ¦Òexcelªþ¥ó»¡©úÁÂÁ¡C |
-
-
1.zip
(8.69 KB)
|
|
|
|
|
|
- ©«¤l
- 52
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 119
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-6
- ³Ì«áµn¿ý
- 2022-6-7
|
¦^´_ 2# luhpro
ÁÂÁÂiuhprohu¥ý¶i«ü¾É,³o¤@Ó¦n¤èªk,¥u¬O¦W³æ¦³´X¦Êµ§¡A§Únªº¥u¬O§ä¥X¤@µ§¦b"¦¨ªG³ø§i.doc"²Ä¤@¶¶ñ¤J¬ÛÃö°ò¥»¸ê®Æ¡AÄò¶»Ý¬OªÅ¥Õ¶n¼¶¼g¬ÛÃö³ø§i¡C
iuhprohu¥ý¶i¥i§_¦pªþ¥ó»Ý¨Dµ¹¤©¨ó§UÁÂÁ±z¡C |
|
|
|
|
|
|
- ©«¤l
- 52
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 119
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-6
- ³Ì«áµn¿ý
- 2022-6-7
|
¦^´_ 4# GBKEE
·PÁÂGBKEEª©¥D¤j¤O¨ó§U±zªºµ{¦¡¥i¥H¦p¤p²Ä©Ò»Ý¹B§@¡A¤µ·Q½Ðª©¥D¦A¦¸¨ó§U§ó§ï¶}±ÒDocuments.Open "d:\¦¨ªG³ø §i.doc"쥻¥u¦³¤@¶Y§ï¦¨¤G¶¡A ¥Ø«eµ{¦¡¥u¯àÅã¥Ü²Ä¤@¶(§@¥Î¶)¦]¦Û¤v¤~²¨¾Ç²L¡A§ä´M¬ÛÃö¸ê®Æ¸Õ¤F«Ü¤[ÁÙ¬O¥¢±Ñ¡A½Ðª©¥D¦Aµ¹¤©¨ó§UÁÂÁ¡C
Dim Rng As Range
Private Sub TextBox1_Change()
If Trim(TextBox1) <> "" Then '¥h°£¨â®ÇªÅ¥Õ¦r¤¸«áªºTextBox1
Set Rng = Sheets("SHEET1").Range("a:a").Find(Trim(TextBox1), LOOKAT:=xlWhole)
' .Range("a:a") ´M§ä:¨¥÷ÃÒ¦r¸¹
If Not Rng Is Nothing Then
If MsgBox(TextBox1 & vbLf & "¦L¦C?", vbYesNo, "¦¨ªG³ø §i") = vbYes Then Ex
End If
End If
End Sub
Private Sub Ex()
Dim AR, i As Integer
AR = Array("¦¨ªG³ø §i", "H", "B", "D", "A", "I", "J", "K")
'ªíÀY¦UÄæ¦ì¶µ¥Ø¦r¦ê¶¡¹j½Ð¦Û¦æ½Õ¾ã»PÅã¥Ü¦b "¦¨ªG³ø §i.DOC,ªº¦r¦ê¶¡¹j¤@P
For i = 1 To UBound(AR)
AR(i) = Cells(1, AR(i)) & " : " & Rng.Cells(1, AR(i))
'¾É¤J ¨CÄæ¦ìªºªíÀY&":"&¦r¦ê(¤º®e)
Next
With CreateObject("WORD.APPLICATION")
.Visible = True
.Documents.Open "d:\¦¨ªG³ø §i.doc"ìÀÉ®×¥u¦³¤@¶²{§ï¦³¤G¶¡An³o¤G¶¯àÀx¦s¦b"d:\¦¨ªG³ø §i.doc"
With .ActiveDocument
.Range(.Range.Start, .Range.End).Text = Join(AR, vbLf)
With .Range
.Font.Size = 16
.ParagraphFormat.Alignment = 0 'wdAlignParagraphLeft '¾a¥ª
With .Paragraphs(1).Range
.Font.Size = 24
.ParagraphFormat.Alignment = 1 ' wdAlignParagraphCenter '¦Ü¤¤
End With
End With
.PrintOut '¦L¦C
.Close
End With
.Quit
End With
End Sub |
|
|
|
|
|
|
- ©«¤l
- 52
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 119
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-6
- ³Ì«áµn¿ý
- 2022-6-7
|
¦^´_ 6# GBKEE
.Documents.Open "d:\¦¨ªG³ø §i.doc"ìÀÉ®×¥u¦³¤@¶²{§ï¦¨¦³¤G¶¡An³o¤G¶¯àÀx¦s¦b"d:\¦¨ªG³ø §i.doc"
With .ActiveDocument
¶} ±Òd:\¦¨ªG³ø §i.docY§ï¦¨¦³¤G¶,¸g With .ActiveDocument«á¥u³Ñ²Ä¤@¶,¥i¥H±N¤G¶³£«O¦s¶Ü?¥i¯à¬O²Ä¤G¶¨S¦³§@¥Îªºì¬G©Ò¥H¤£¨£¤F¡C |
|
|
|
|
|
|
- ©«¤l
- 52
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 119
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-6
- ³Ì«áµn¿ý
- 2022-6-7
|
ÁÂÁÂGBKEEª©¥D¤j¤O¨ó§U¡A¸g±z¦A¦¸×§ïµ{¦¡¤v²Å¦X¤p²Ä»Ý¨D¡C |
|
|
|
|
|
|