'增加一个列表框 List1 以下代码在窗体中 '运行后,注意运行后让Excel为背景窗口.即不要让别的窗口盖住Excel.当然,此运行的窗口除外,不然看不到效果. Dim xlApp As Object Private Sub Form_Load() Set xlApp = GetObject(, "Excel.Application") For i = 1 To xlApp.Workbooks.Count List1.AddItem xlApp.Workbooks(i).Name Next End SubPrivate Sub List1_Click() xlApp.Workbooks(List1.Text).Activate End Sub
'接上.你要先打开Excel才能正常运行. '建议多打开几个Excel以观看使用效果
'再来一个. '增加二个列表框 List1 List2 以下代码在窗体中 '运行后,注意运行后让Excel为背景窗口.即不要让别的窗口盖住Excel.当然,此运行的窗口除外,不然看不到效果. Dim xlApp As Object Private Sub Form_Load() On Error Resume Next Set xlApp = GetObject(, "Excel.Application") If Err Then MsgBox "要先打开Excel" Exit Sub End If
For i = 1 To xlApp.Workbooks.Count List1.AddItem xlApp.Workbooks(i).Name Next End SubPrivate Sub List1_Click() xlApp.Workbooks(List1.Text).Activate List2.Clear For i = 1 To xlApp.Workbooks(List1.Text).worksheets.Count List2.AddItem xlApp.Workbooks(List1.Text).worksheets(i).Name Next End Sub Private Sub List2_Click() xlApp.Workbooks(List1.Text).worksheets(List2.Text).Activate End Sub
'增加一个列表框 List1 以下代码在窗体中
'运行后,注意运行后让Excel为背景窗口.即不要让别的窗口盖住Excel.当然,此运行的窗口除外,不然看不到效果.
Dim xlApp As Object
Private Sub Form_Load() Set xlApp = GetObject(, "Excel.Application")
For i = 1 To xlApp.Workbooks.Count
List1.AddItem xlApp.Workbooks(i).Name
Next
End SubPrivate Sub List1_Click()
xlApp.Workbooks(List1.Text).Activate
End Sub
'接上.你要先打开Excel才能正常运行.
'建议多打开几个Excel以观看使用效果
'再来一个.
'增加二个列表框 List1 List2 以下代码在窗体中
'运行后,注意运行后让Excel为背景窗口.即不要让别的窗口盖住Excel.当然,此运行的窗口除外,不然看不到效果.
Dim xlApp As Object
Private Sub Form_Load()
On Error Resume Next
Set xlApp = GetObject(, "Excel.Application")
If Err Then
MsgBox "要先打开Excel"
Exit Sub
End If
For i = 1 To xlApp.Workbooks.Count
List1.AddItem xlApp.Workbooks(i).Name
Next
End SubPrivate Sub List1_Click()
xlApp.Workbooks(List1.Text).Activate
List2.Clear
For i = 1 To xlApp.Workbooks(List1.Text).worksheets.Count
List2.AddItem xlApp.Workbooks(List1.Text).worksheets(i).Name
Next
End Sub
Private Sub List2_Click()
xlApp.Workbooks(List1.Text).worksheets(List2.Text).Activate
End Sub