Daniel,
Excellent. Thank you very much. Both of these work exactly as I
wished.
I have now located ENVIRON in the VBA-Help. I see that I can use this
to read other environment variables as shown in
ControlPanel>System>Advanced>EnvironmentVariables. However, COMPUTER-
NAME and USER-NAME are no
bject: RE: $$Excel-Macros$$ Obtaining system information
Try :
ComputerName = Environ("ComputerName")
User = Environ("UserName")
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de keelta
Envoyé : merc
Try :
ComputerName = Environ("ComputerName")
User = Environ("UserName")
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de keelta
Envoyé : mercredi 15 décembre 2010 15:22
À : MS EXCEL AND VBA MACROS
Objet : $$Excel-Macros$$ O
