In my spreadsheet i do a lot of xml requests and i've noticed then when they refresh not all of them will update, or they will fail.To combat this i want to try and implement a type of caching, due to the results from the xml query never changing.Ive tried a few approaches but cant get anything to work, and was wondering if there are simplier methods then what im attempting.Ive tried.[*]Create a new worksheet and store the data, in a type of CSV sheet. I would hide the sheet and this would have been the best method.[*]Ive tried to create a global collection and saved the results into that, which failed.[*]Ive also tried to save the xml to file and reload it each time that you make a call it would load from file instead.Im sure asking for an answer in a certain way is wrong in some way but... if you could provide me with two functions one to setCache and one to getCache it would be the best.
Saving and Loading from a cache in Excel
- Thread starter dewa
- Start date