Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving data from online excel spreadsheet.
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
(World Cup spreadsheet Excel program) - .nzb www.vmp-online.co.uk (1/1) | Excel Discussion (Misc queries) | |||
Retrieving Data: Speed of beating down rows vs retrieving from array? | Excel Programming | |||
Associate an e-mailed Excel spreadsheet with Office Online | Excel Discussion (Misc queries) | |||
Retrieving previously entered userform data from saved spreadsheet | Excel Programming | |||
Editable Excel Spreadsheet Online? | Excel Programming |