T
TFriis
Hi.
I've created a workbook that retrieves data from an online spreadsheet
once a day. - The problem is that it seems like the data is not
updated in online workbook when I open it (even though it is).
I figured the problem was the cache - so I found a macro that clears
the cache, but it didn't help. It feels like excel keeps opening some
old tmp file? But I can't figure out where this "tmp" file is located?
Or if it might be another issue?
The code (as a snippet) is shown beneath.
Public Declare Function DeleteUrlCacheEntry Lib "wininet" _
Alias "DeleteUrlCacheEntryA" _
(ByVal lpszUrlName As String) As Long
Sub Mac()
Dim FileLink as string
FileLink = "http://www.ftnet.dk/graphics/Finanstilsynet/Mediafiles/
newdoc/" _
& "Diskonteringsrente/Justeret_diskonteringssatser.xls"
Call DeleteUrlCacheEntry(FileLink)
Workbooks.Open Filename:=FileLink
End Sub
I know this is difficult for you to test, since the spreadsheet is
only updated once a day (before lunch GMT+1) - but you've might run
into the same issue? Hope that there is an easy solution.
I've created a workbook that retrieves data from an online spreadsheet
once a day. - The problem is that it seems like the data is not
updated in online workbook when I open it (even though it is).
I figured the problem was the cache - so I found a macro that clears
the cache, but it didn't help. It feels like excel keeps opening some
old tmp file? But I can't figure out where this "tmp" file is located?
Or if it might be another issue?
The code (as a snippet) is shown beneath.
Public Declare Function DeleteUrlCacheEntry Lib "wininet" _
Alias "DeleteUrlCacheEntryA" _
(ByVal lpszUrlName As String) As Long
Sub Mac()
Dim FileLink as string
FileLink = "http://www.ftnet.dk/graphics/Finanstilsynet/Mediafiles/
newdoc/" _
& "Diskonteringsrente/Justeret_diskonteringssatser.xls"
Call DeleteUrlCacheEntry(FileLink)
Workbooks.Open Filename:=FileLink
End Sub
I know this is difficult for you to test, since the spreadsheet is
only updated once a day (before lunch GMT+1) - but you've might run
into the same issue? Hope that there is an easy solution.