Script/ Macro in Excel, by clicking on a cell
- by Noob Doob
There's something I want to do in Excel 2010. Specifically, I want to be able to make the open sheet load data from a text file, by clicking -important- on a cell of the current open worksheet.
So my specific needs are:
If it is possible in some way, to start a macro/script by clicking on a cell.
About the script/macro:
What would be the preferable, by your opinion, way of implementation.
And more specifically, how to automatically import the data needed, only by clicking, without having to continually specify the desirable .txt file each time, only 1 time at max, at start or by using a custom "initalization/configuration" file.