Dim objExcel As Excel.Application
Dim objWorkBook As Excel.Worksheet Set objExcel = CreateObject("excel.application")
Set objWorkBook = objExcel.Workbooks.Open("d:\1.xls")
objExcel.Visible = True '设置活动工作表
Dim objSheet As Excel.Worksheet
Set objSheet = objExcel.Worksheets("sheet1") 为什么这一句Set objWorkBook = objExcel.Workbooks.Open("d:\1.xls")
总是提示类型不匹配
我想打开已经存在的excel
Dim objWorkBook As Excel.Worksheet Set objExcel = CreateObject("excel.application")
Set objWorkBook = objExcel.Workbooks.Open("d:\1.xls")
objExcel.Visible = True '设置活动工作表
Dim objSheet As Excel.Worksheet
Set objSheet = objExcel.Worksheets("sheet1") 为什么这一句Set objWorkBook = objExcel.Workbooks.Open("d:\1.xls")
总是提示类型不匹配
我想打开已经存在的excel
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货