Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a template with an automatic Number Systen | Excel Worksheet Functions | |||
Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
Three Variables | Excel Worksheet Functions | |||
How to see all variables? | Excel Programming | |||
Variables | Excel Programming |