Home » Blogs » Nick's blog

XLA routines: EE_OpenFromTemp

Nick's picture
Submitted by Nick on 31 January, 2015 - 09:14
EE_OpenFromTemp is a time-saving function that copies a file to temp dir if it's different then opens it from temp - don't use this function if you are looking to modify the file 
Function EE_OpenFromTemp(strFullFilePath As String) As Boolean
'Takes a full file name and path
'Opens the same file but from temp path
'Returns false if unsuccessful
'http://excelexperts.com/xla-routines-eeOpenFromTemp    for updates on this function

    Call EE_CopyFile(strFullFilePath, Environ("Temp"))
    On Error Resume Next
        Workbooks.Open (Environ("Temp") & Application.PathSeparator & EE_FileNameFromFilePath(strFullFilePath))
        EE_OpenFromTemp = (Err.Number = 0)
    Err.Clear: On Error GoTo 0: On Error GoTo -1
End Function
»