'C:\1.Xls 文件中的 Sheet1 工作本中有一个 TextBox1 的文本框. '以下代码调试通过. Option ExplicitPrivate Sub Form_Load() Dim xlApp As New Excel.Application Dim xlWork As Excel.Workbook Dim xlSheet As Object '注意此处
Set xlWork = xlApp.Workbooks.Open("C:\1.xls") Set xlSheet = xlWork.Worksheets("Sheet1") MsgBox xlSheet.textbox1.Text
'以下代码调试通过.
Option ExplicitPrivate Sub Form_Load()
Dim xlApp As New Excel.Application
Dim xlWork As Excel.Workbook
Dim xlSheet As Object '注意此处
Set xlWork = xlApp.Workbooks.Open("C:\1.xls")
Set xlSheet = xlWork.Worksheets("Sheet1")
MsgBox xlSheet.textbox1.Text
End Sub