View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Finding temp folder. Environment variable?

This worked ok for me:

MsgBox Environ("Temp")

in WindowsXP Home

Don Wiss wrote:

I'm starting an enhancement where my spreadsheet will save a bunch of PDF
files into a folder, and then I'll call some application on the server that
will append them all together. For the appending I'm looking at:
http://appligent.com/products/append...nd_pdf_pro.php

It would make sense to me to put all the files in a folder under the Temp
folder. My recollection is the path to the temp folder was in an
environment variable. How do I read it? Or is it someplace in the Registry?
I have code to read that, if I know the location where it is stored.

Don <www.donwiss.com (e-mail link at home page bottom).


--

Dave Peterson