View Single Post
 
Old 10-31-2014, 08:47 AM
efuzzy efuzzy is offline Windows XP Office 2003
Novice
 
Join Date: Oct 2014
Posts: 1
efuzzy is on a distinguished road
Default csv-import to an external file via link-connection

Hello,
I want to solve the following task:
- I have an excell-file with different spreadsheets_En for evaluating different equities with quote-data
- I download the actual quotes via downloading an appropriate watchlist via csv-export--- I can do that.
- now I want to see this downloading immediately in one of the spreadsheets via a link between the downloading file and the forementioned spreadsheet-Q and also in the speadsheets of the different equities via appropriate relations of the cells in spreadsheet-Q and the spreadsheets_En
Can I do that without VBA-code, how I guess I read it in an equity-forum?
There is mentioned: One file in csv-format can be connected into an excell-file as an additional page if you import the csv-file as a "link to an external file".
What to do?
Or is that perhaps possible only with OpenOffice?

Thanks
Reply With Quote