View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Patrick Dave Patrick is offline
external usenet poster
 
Posts: 249
Default Finding temp folder. Environment variable?

MsgBox Environ$("temp")

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"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).