Frederick:

Environ("Temp")

will return a string that is the path to the windows temp directory.

--
Dick Kusleika
MS MVP - Excel
www.dailydoseofexcel.com

Frederick Chow wrote:
Hi all,

Is there any way to access a local workstation's TEMP directory?
Maybe it needs a Windows API, but I don't know how to do it. Thanks
for your assistance.

Frederick Chow
Hong Kong.