![]() |
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? |
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