ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] VBA¸ô®|¸Ì­±­Y¦³ÅܼơA¦p¦ó§ï¦Û°Ê§ì?

¦^´_ 3# RCRG

Option Explicit '«Å§iGetUserName 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

³o¬qµ{¦¡¥i¥H§ì¥XWindowsµn¤JªÌ±b¸¹(UserName),½Ð¨Ì»Ý¨D¦Û¦æ­×§ï

TOP

¦^´_ 5# RCRG

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

TOP

        ÀR«ä¦Û¦b : ¦³¦h¤Ö¤O¶q´N°µ¦h¤Ö¨Æ¡A¤£­n¤ß¦sµ¥«Ý¡Aµ¥«Ý¤~·|¸¨ªÅ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD