simple question; if my PC reboots and I have a spreadsheet update in progress...

[Gates Ouimette]

where is the exact temp location on my PC where the temp
file may be found? It probably varies by PC but there
must be some type of standard/recommendation/best practice?

Thanks..

 

[Chip Pearson]

Try something like


Declare Function GetTempPath Lib "kernel32" Alias "GetTempPathA" _
(ByVal nBufferLength As Long, ByVal lpBuffer As String) As
Long
Sub AAA()
Dim TempPath As String
Dim L As Long
TempPath = String(255, " ")
L = GetTempPath(255, TempPath)
TempPath = Left(TempPath, L)
Debug.Print TempPath
End Sub



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Dave Peterson]

Chip gave you a method to find the windows temp folder for the current user.

But if you meant where the autorecovery (xl2002) file is kept, you can look at:
Tools|Options|Save Tab

But I'm not sure what other temp file you'd be looking for.