求帮助,现有EXCEL已经打开,如何实现连接已经打开的EXCEL然后对任意的SHEET进行操作?
Dim xlapp1 As Excel.Application
Dim xlbook1 As Excel.Workbook
Dim xlsheet1 As Excel.Worksheet Set xlapp = CreateObject("Excel.Application")
Set xlbook = ?????————————————这里是不是填上什么代码就解决了?
Set xlsheet = xlbook.Worksheets("页码")求大神帮助
Dim xlapp1 As Excel.Application
Dim xlbook1 As Excel.Workbook
Dim xlsheet1 As Excel.Worksheet Set xlapp = CreateObject("Excel.Application")
Set xlbook = ?????————————————这里是不是填上什么代码就解决了?
Set xlsheet = xlbook.Worksheets("页码")求大神帮助
Set xlbook1 = xlapp1.Workbooks("Book1.xls") '按文件名取得打开的文件