Environ Function Workaround

[PatrickRW]

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

Is there an Excel 2004 workaround for the Visual Basic Environ function?

I am attempting to automatically determine the user in visual basic (i.e. System Perferences»Account) in my Excel Programs.

I have searched the Web for two days without a solution, I thought I would tweak the expects, Thanks, Patrick

 

[Bob Greenblatt]

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

Is there an Excel 2004 workaround for the Visual Basic Environ function?

I am attempting to automatically determine the user in visual basic (i.e.
System Perferences»Account) in my Excel Programs.

I have searched the Web for two days without a solution, I thought I would
tweak the expects, Thanks, Patrick

Other than Application.user, I don't know how to get the name of the logged
on user.

 

[PatrickRW]

Thank You so much (and really a fast answer)

Application.UserName.... Produces the user's name listed under Excel's Preferences»General»User Name: which easily can be different for each account in the Mac OS X world. Hence, my application can now easily determine the user partition and act accordingly.

It is not the same result as the Environ Function, but it is an Excellent and simple Workaround for my math research, and a solution that my brain could not think of. Thanks, Again, Patrick