Public Declare Function FindExecutable Lib "shell32.dll" Alias "FindExecutableA" (ByVal lpFile As String, ByVal lpDirectory As String, ByVal lpResult As String) As Long上面的函数是查找.exe文件的。或许有用。
判断机器又没有安装excel2000和调用excel2000可以尝试一下这方法: on error goto error Dim xl As Excel.Application Set xl = CreateObject("Excel.Application") /*excel对象创建失败*/ Xl.Workbooks.Add Xl.Range("a1").Value = "你好!" Xl.Visible = True error: megbox "请安装excel2000" 直接可以打开excel,不用使用shell执行。
on error goto error
Dim xl As Excel.Application
Set xl = CreateObject("Excel.Application")
/*excel对象创建失败*/
Xl.Workbooks.Add
Xl.Range("a1").Value = "你好!"
Xl.Visible = True
error:
megbox "请安装excel2000"
直接可以打开excel,不用使用shell执行。