ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   systen variables (https://www.excelbanter.com/excel-programming/300820-systen-variables.html)

John Holderman

systen variables
 
The Environ function, index 21, provides the TEMP directoty but it also
included the words "TEMP=" in the text. Is there a way to either remove the
first 5 charicatars from a string or get just the directory without the
"TEMP=" added?



Bob Phillips[_6_]

systen variables
 
It's SystemDrive on my machine!

And that highlights a problem using the index, you cannot rely on a variable
being ion a fixed position.

Use Environ("Temp") instead, and you just get the value.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"John Holderman" wrote in message
link.net...
The Environ function, index 21, provides the TEMP directoty but it also
included the words "TEMP=" in the text. Is there a way to either remove

the
first 5 charicatars from a string or get just the directory without the
"TEMP=" added?






All times are GMT +1. The time now is 10:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com