Public miRNAerPath as String
Public miRNAerSpe as StringPrivate Sub AA()
for m=1 to 10
miRNAerPath="E:\" & m
miRNAerSpe="aaa" & m
Call GenomeIn
next
End SubPrivate Sub GenomeIn()
'===================建立文件夹===============================
Dim VBExcel As Excel.Application
'创建excel book
Set VBExcel = CreateObject("Excel.Application")
VBExcel.Visible = True
With VBExcel
.Workbooks.Add
ActiveWorkbook.SaveAs miRNAerPath & "\" & miRNAerSpe & "\" & miRNAerSpe & ".xls"
Call GenomeInput
ActiveWorkbook.Close
.Quit
End With
End Sub请问一下,运行中当m大于2时总是出现“with块变量未设置”,调试时在上面红色那一句。我不清楚什么东西没有加载,请大家帮我修改一下。
Public miRNAerSpe as StringPrivate Sub AA()
for m=1 to 10
miRNAerPath="E:\" & m
miRNAerSpe="aaa" & m
Call GenomeIn
next
End SubPrivate Sub GenomeIn()
'===================建立文件夹===============================
Dim VBExcel As Excel.Application
'创建excel book
Set VBExcel = CreateObject("Excel.Application")
VBExcel.Visible = True
With VBExcel
.Workbooks.Add
ActiveWorkbook.SaveAs miRNAerPath & "\" & miRNAerSpe & "\" & miRNAerSpe & ".xls"
Call GenomeInput
ActiveWorkbook.Close
.Quit
End With
End Sub请问一下,运行中当m大于2时总是出现“with块变量未设置”,调试时在上面红色那一句。我不清楚什么东西没有加载,请大家帮我修改一下。
.Workbooks.Add
这里的.add就创建了呀
dim xlsDestBook As Excel.Workbook
set xlsDestBook =VBExcel.Workbooks.Add()
xlsDestBook.SaveAs "e:\1.xls"