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
|