Grace has attended:
Excel Intermediate course
Excel Advanced course
Excel training
When importing external data is it possible to import data from a intranet which lists around twenty csv files and choose the file you want based on the date embedded within the file name?
On the course it was shown how to import for exmaple market data and update it with the '!' button but I need to know how to import a csv file of a specific date onto an excel spreadsheet to manipulate further.
RE: Excel training
Hi Grace, thanks for the query. When you import data you have to browse to the file you want to import from, so you choose which file from the filename at that stage. If the CSV files are on an intranet site you could browse to the server folder if you are correctly networked, if not you have to download the CSV files to an offline folder and then import the one you want. Other than that, to import CSV files directly from an intranet site would require a bit of code running in the background to access the intranet site, connect to the correct file and then bring it into Excel, there is no standard tool to do this.
Hope this helps,
Anthony
