thanhvanchi
12-04-2016, 01:33 AM
Hello everybody.
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?
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?