Hello,

I would like to put Excel file into such a directory
in which I will be sure that has security settings ReadWrite.

If I know, on the arbitrary computer,
that Excel is working OK,
it means that Excel's TEMP directory has
under logged user security settings = ReadWrite.

If I set "C:\Documents and Settings\******\Local Settings\Temp"
directory to ReadOnly,
the Excel will not work.

The C function GetTempPath returns
the above directory, may The Excel using this C function?

Do anybody know which way the Excel determine
where the TEMP directory is?

Thanks

Miso

ENVIRON("TEMP") or ENVIRON("TMP") should give you that information.

Also, with a reference to the Windows Scripting Host, the
GetSpecialFolder method of the FileSystemObject object will give you
what you want.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <e$(E-Mail Removed)>, (E-Mail Removed)
says...
> Hello,
>
> I would like to put Excel file into such a directory
> in which I will be sure that has security settings ReadWrite.
>
> If I know, on the arbitrary computer,
> that Excel is working OK,
> it means that Excel's TEMP directory has
> under logged user security settings = ReadWrite.
>
> If I set "C:\Documents and Settings\******\Local Settings\Temp"
> directory to ReadOnly,
> the Excel will not work.
>
> The C function GetTempPath returns
> the above directory, may The Excel using this C function?
>
> Do anybody know which way the Excel determine
> where the TEMP directory is?
>
> Thanks
>
> Miso
>
>
>
>

Hi Miso,

For me, until now this API always return Excel temp folder:

Private Declare Function GetTempPath Lib "kernel32" _
Alias "GetTempPathA" (ByVal nBufferLength As Long, _
ByVal lpBuffer As String) As Long

Function TempFolder() As String
'Get Temp Folder
Dim fctRet As Long
TempFolder = String$(255, 0)
fctRet = GetTempPath(255, TempFolder)
If fctRet <> 0 Then
TempFolder = Left(TempFolder, fctRet)
If Right(TempFolder, 1) = "\" Then TempFolder = Left(TempFolder,
Len(TempFolder) - 1)
Else
TempFolder = ""
End If
End Function


"Miso" <(E-Mail Removed)> escreveu na mensagem
news:e$(E-Mail Removed)...
> Hello,
>
> I would like to put Excel file into such a directory
> in which I will be sure that has security settings ReadWrite.
>
> If I know, on the arbitrary computer,
> that Excel is working OK,
> it means that Excel's TEMP directory has
> under logged user security settings = ReadWrite.
>
> If I set "C:\Documents and Settings\******\Local Settings\Temp"
> directory to ReadOnly,
> the Excel will not work.
>
> The C function GetTempPath returns
> the above directory, may The Excel using this C function?
>
> Do anybody know which way the Excel determine
> where the TEMP directory is?
>
> Thanks
>
> Miso
>
>
>