View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Robert ap Rhys Robert ap Rhys is offline
external usenet poster
 
Posts: 21
Default Save files to generalized location?


"Tom Ogilvy" wrote in message
...
Yes, you would do it that way or you could just use the environ function
from VBA


You're right, of course. Except that I had a bad experience back in the day
of NT4 where I had a bunch of machines some of which had a TMP environmental
variable and some of which had TEMP, but none had both. Easy to work around,
of course, but I've automatically avoided it ever since.

Robert