返回列表 上一主題 發帖

[發問] VBA路徑裡面若有變數,如何改自動抓?

回復 3# RCRG

Option Explicit '宣告GetUserName Function
Private Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" _
(ByVal lpBuffer As String, _
nSize As Long) As Long

Sub Get_User_Name()
Dim lpBuff As String * 25
Dim ret As Long, UserName As String
ret = GetUserName(lpBuff, 25)
UserName = Left(lpBuff, InStr(lpBuff, Chr(0)) - 1)
Debug.Print UserName
End Sub

這段程式可以抓出Windows登入者帳號(UserName),請依需求自行修改

TOP

回復 5# RCRG

"C:\Users\" + UserName + "\Desktop\TEST\TEST.xlsm"

TOP

        靜思自在 : 能善用時間的人,必能掌握自己努力的方向。
返回列表 上一主題