Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Office XP compatiblity- Signed in user
The following function worked fine in my previous version of Excel but does
not work in XP. It tries to retrieve the logged in user. Thanks for the help! Private Declare Function GetUserName Lib "advapi32.dll"_ Alias "GetUserNameA" (ByVal lpBuffer As String, nSize as Long)_ As Long Funtion UserName() As String Dim Buffer as String * 100 Dim BuffLen as Long BuffLen=100 GetUserName Buffer, BuffLen UserName= Left(Buffer, BuffLen - 1) End Function 'The error I get is "Compile error- can't find project or library" Thanks for any help you can give. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Office End-User License Agreement | Excel Discussion (Misc queries) | |||
Setting Office 2007 User Name | Excel Discussion (Misc queries) | |||
Workbook Created By Signed Addin Is Itself Not Signed | Excel Discussion (Misc queries) | |||
2003 to 2000 CSV compatiblity issues | Excel Discussion (Misc queries) | |||
Help me help a user in our office | Excel Worksheet Functions |