Retrieving data from online excel spreadsheet.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top