Dim zsbexcel As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.WorksheetPrivate Sub Command1_Click()
Set zsbexcel = New Excel.Application
zsbexcel.Visible = True
Set xlBook = zsbexcel.Workbooks.Open(" & App.Path & " \ book1.xls)
zsbexcel.SheetsInNewWorkbook = 1 Set zsbworkbook = zsbexcel.Workbooks.Add运行后提示要求对象报这句错误:
Set xlBook = zsbexcel.Workbooks.Open(" & App.Path & " \ book1.xls)
程序目录下有book1.xls这个文件
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.WorksheetPrivate Sub Command1_Click()
Set zsbexcel = New Excel.Application
zsbexcel.Visible = True
Set xlBook = zsbexcel.Workbooks.Open(" & App.Path & " \ book1.xls)
zsbexcel.SheetsInNewWorkbook = 1 Set zsbworkbook = zsbexcel.Workbooks.Add运行后提示要求对象报这句错误:
Set xlBook = zsbexcel.Workbooks.Open(" & App.Path & " \ book1.xls)
程序目录下有book1.xls这个文件
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货