Private Sub Command2_Click()
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
Dim FileName, SheetName As String
FileName = "c:\11.xls"
SheetName = "sheet1"
Set xlApp = CreateObject("Excel.Application") 'å建EXCEL对象
Set xlBook = xlApp.Workbooks.Open(FileName) 'æå¼å·²ç»åå¨çEXCEL工件簿æ件
xlApp.Visible = False '设置EXCEL对象å¯è§ï¼æä¸å¯è§ï¼
Set xlSheet = xlBook.Worksheets(SheetName) '设置活å¨å·¥ä½è¡¨
xlSheet.Shapes("textbox1").DrawingObject.object.Text = "设置æ§ä»¶å·¥å
·é¢æ¿étextboxå
容"
xlSheet.Shapes("ææ¬æ¡ 3").TextFrame.Characters.Text = "设置ç»å¾å·¥å
·æ éææ¬æ¡å
容"
Sheets(SheetName).textbox1.Text = "设置æ§ä»¶å·¥å
·é¢æ¿étextboxå
容" 'ç»textèµå¼ï¼ä¸è½ç´æ¥ç¨ xlsheet.textbox1.text
xlApp.DisplayAlerts = False
xlBook.Save
xlBook.Close (True) 'å
³éå·¥ä½ç°¿
xlApp.Quit 'ç»æEXCEL对象
Set xlApp = Nothing 'éæ¾xlApp对象
End Sub
温馨提示:答案为网友推荐,仅供参考