| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
refresh data from a intermediate excel data file (not opened)
Hi I would like to import data separate excel file, which itself consolidates data from mutliple CSV files. CSV files --- Excel Data File --- Excel Results File My question : how do I refresh the Excel Data File programmaticaly ? I tried to open/close it, with the refresh on open option checked, but it asks me if I trust the data source, etc etc.. This is not ideal and machine dependant... How do I refresh it transparently ? Matthieu |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic "data refresh" when XLS file is opened? | Excel Discussion (Misc queries) | |||
| How do I get an intermediate value between data points on a graph? | Excel Discussion (Misc queries) | |||
| Refresh Imported Data - Does the Excel file have to be open? | Excel Discussion (Misc queries) | |||
| How to auto-refresh Pivot data when open Excel file? | Excel Worksheet Functions | |||
| Best way to refresh data from an external file | Excel Programming | |||
Hybrid Mode
