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

  • Thread starter Thread starter Gates Ouimette
  • Start date Start date
G

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..
 
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)
 
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.
 
Back
Top