Obtain path for TEMP folder-VBForums - VBForums - Visual Basic and VB .NET Discussions and More!

I have a vba macro in excel that creates a temporary file. Currently I have the path hardcoded for the temp folder. However I now need to use the file on both XP and Vista computers. Please can any one advise of a simple method to obtain the path to the t

www.vbforums.com