- ©«¤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
|
¦^´_ 1# dechiuan999
§Ú WORD ªºVBA ¤£¤Ó¼ô, ¸Õ¸Õ¬Ý½Æ»s¨ìExcel ¦b¥h³B²z- Sub ¥¨¶°2()
- Application.ActiveDocument.Range.Copy
- Word_vba
- End Sub
- Sub Word_vba()
- Dim xlWkApp As Object, xlWk As Object
- Set xlWkApp = CreateObject("excel.application")
- Application.DisplayAlerts = False 'Ãö³¬¨t²Îªº¸ß°Ýµøµ¡
- With xlWkApp
- .Visible = True
- Set xlWk = .workbooks.Open(FileName:="d:\¸Õºâªí\Book3.xls", Password:="1234", IgnoreReadOnlyRecommended:=False)
- ' xlWk.Sheets(1).Range("c3") = ActiveDocument.Tables(1).Cell(1, 1)
- xlWk.Sheets(1).Paste
- xlWk.Close False
- End With
- xlWkApp.Quit
- Set xlWkApp = Nothing
- End Sub
½Æ»s¥N½X |
|