Thanks for the information, but how do you do this? This all has to be
silent behind the scenes stuff which I didn't mention. The reason for the
request is we have over 1000 machines and we are trying to determine which
notebooks have a recalled battery. We have an application that will dump the
information to a .csv file and I can use the information there, but it only
provides the serial number of the machine and battery - it also provides a
"Y" or "N" and only Sony batteries are being recalled. So I have been using
..bat and .cmd files to push this app to the notebook, using the set command
and capture the computername and username in one file and then save it to a
server, but without the username and computername in the file but when the
file is created, I user %username%%computername%.csv as the file name - I
don't want to have to key in 1000 computername and usernames into the .csv.
If this makes sense, I would appreciate any better way to handle this.

Thanks in advance.
BD


"Kevin B" wrote:

you can get the username using VBA with the following command

application.UserName

To the best of my knowledge, for other system variables you'll have to do a
Windows API call
--
Kevin Backmann


"bdickert" wrote:

I am trying to capture information into an Excel Spreadsheet specifically a
couple of System Environment Variables like Computername, Username, etc. Is
this possible?
Please explain if this is possible. Thanks in advance. BD