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

App.Path 你程序所在的文件夹目录,看看对比一下,你需要访问的文件对不?!

FileCopy App.Path + "\qqqq\wwww.xlt ", lujing + "\qqq\tmp.xlt "
'** wwww.xlt shi excel mo ban
FileName = App.Path + "\qqqq\wwww.xlt "

你的代码没有贴完整,无法调试。
请来个完整的,我再帮你。

\qqqq\wwww.xls