請教諸位先進:
Sub Main()
Dim objXLApp
Dim objXLBook
Dim fso3
Set fso3 = CreateObject("Scripting.FileSystemObject")
GetAn3 = fso3.GetbaseName(myself)
MsgBox GetAn3
End Sub
以上轉為*.exe 欲取得本身之檔名 myself應如何下語法作者: Min 時間: 2010-11-5 21:11
感謝 Min 大大
已在VB區讓您給解決了 f1 = App.EXEName f1 就是BaseName
以下全文供大家參考 轉成執行檔*.exe後可以開同檔名的*.xls
不用再去理會安全性層級問題
Sub Main()
Dim f1
f1 = App.EXEName
Dim fso, f As Object
Set fso = CreateObject("Scripting.FileSystemObject")
Set f = fso.GetFile(f1 & ".xls")
Dim n
n = fso.GetParentFolderName(f.Path)
Set objXLApp = CreateObject("Excel.Application")
objXLApp.Visible = True
Set objXLBook = objXLApp.Workbooks.Open(n & "\" & f1 & ".xls")
Set objXLBook = Nothing
Set objXLApp = Nothing
Set fso = Nothing
Set n = Nothing
Set f = Nothing
End Sub作者: Min 時間: 2010-11-6 00:44