VB路径未找到?
来源:百度知道 编辑:UC知道 时间:2024/05/29 15:04:36
Dim i As Integer, j As Integer
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlsheet As Excel.Worksheet
FileCopy App.Path + "\qqqq\wwww.xlt ", lujing + "\qqq\tmp.xlt "
'** wwww.xlt shi excel mo ban
FileName = App.Path + "\qqqq\wwww.xls "
Set xlApp = CreateObject("Excel.Application ")
Set xlBook = xlApp.Workbooks.Open(FileName)
xlApp.Visible = True
Set xlsheet = xlBook.Sheets("sheet1 ")
With xlsheet
For i = 0 To Grid1.Rows - 1
Grid1.Row = i
For j = 0 To 14
Grid1.Col = j
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlsheet As Excel.Worksheet
FileCopy App.Path + "\qqqq\wwww.xlt ", lujing + "\qqq\tmp.xlt "
'** wwww.xlt shi excel mo ban
FileName = App.Path + "\qqqq\wwww.xls "
Set xlApp = CreateObject("Excel.Application ")
Set xlBook = xlApp.Workbooks.Open(FileName)
xlApp.Visible = True
Set xlsheet = xlBook.Sheets("sheet1 ")
With xlsheet
For i = 0 To Grid1.Rows - 1
Grid1.Row = i
For j = 0 To 14
Grid1.Col = j