Read Data from file

[ethyl]

Is there any way that i program excel to read data from notepad files every time
i open the particular excel file? For example lets say i have created an excel file with 3 worksheets in it. And i also have 3 notepad files with data. Is it possible for excel to link notepad1 with worrksheet 1 and notepad2 with worksheet2 and so on? And ofcourse to read the notepad files every time i open the excel file because the data might have changed.

Thank you for your time.

[WinteE]

I think you should use VBA to solve this, using the 'Input' statement.

[ethyl]

can i have some more information on this please?

[WinteE]

To explain the Input statement is rather difficult. What you also could do is record opening the text-file in excel.

First you start the macro-recorder, and then you open the text-file.
Once you opened the text-file as you want you turn of the macro-recorder.
The VB code to open a textfile is now present as a macro.

If you want full help on this you can send the file to me with the email-link on my site.

Erik