Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel training
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel training
Resolved · Low Priority · Version 2003
Reply Wed 29 Jul 2009, 16:58Delegate Grace said...
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.
For upcoming training course dates see: Pricing & availability
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
Fri 7 Aug 2009: Automatically marked as resolved.
|