Macro(s) for importing txt-file

[Jakob]

Hi All,


I'm trying to make a spreadsheet with a certain function, but don't know how. I'm guessing it takes two macros.


I'd like the spreadsheet to be able to do the following:


1. There should be a bottom where you can tell the spreadsheet/the macro where the txt-file is located. The content is then copied/imported into the spreadsheet.


2. And another bottom, you can push and the content of the txt-file is then copied/imported into the spreadsheet again (overwritten) without having to tell the location of the txt-file again. Sort of a "refresh" bottom, you can push when the content of the txt-file changes


Hope this makes sense.


Any ideas on how to do this?


Thanks...