Thread: using Environ("Temp") correctly

HEy all,

Im using a web query which writes out a temp file to the local directory and then wriets to the excel sheet.

Unfortunately users within my department do not have permission to write to their local c: and hence theer is file access error.

Here:

With ActiveSheet.QueryTables.Add(Connection:="TEXT; c:\JanReportEnding31/01/10.csv", _
Destination:=Range("$A$1"))

How do i enter the Environ("Temp") correctly in the above command?

Regards