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

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

Another option is to use filesystemobject

Sub GetTempFolder_1()
MsgBox Environ("Temp")
'Open folder in Explorer
Shell "explorer.exe " & Environ("Temp"), vbNormalFocus
End Sub

Sub GetTempFolder_2()
Dim FSO As Object, TmpFolder As Object
Set FSO = CreateObject("scripting.filesystemobject")
Set TmpFolder = FSO.GetSpecialFolder(2)
MsgBox TmpFolder
'Open folder in Explorer
Shell "explorer.exe " & TmpFolder, vbNormalFocus
End Sub



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Dave Peterson" wrote in message ...
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

You could try VBA's Environ function

Environ("Temp")


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

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

General one should feel safe/comfortable to have anything in the temp folder
deleted.

If they fit that definition, then that would be a good place.

--
Regards,
Tom Ogilvy

"Don Wiss" wrote in message
...
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).

Don,
Environ ("Temp") is one way.

NickHK

"Don Wiss" wrote in message
...
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).