i have a notepad that have data that i would like to use in excel.
I have read that you can open a notepad in excel with vba and that you can copy contents of the notepad into a string/range. is that possible?
I want to create a macro that will help me open a target file (open as notepad), maybe copy contents to a string.
Because what I really want to do is search through the contents of the text file, and copy a certain string.
the text file contains such dataexample)
MIDlet-Name: Helloword
MIDlet-Version: 1.1.0
MIDlet-Vendor: MyHouse
I want to be able to get the value for "version" or 1.1.0 and copy it to a cell.
Any inputs will be really appreciated. thanks!
I have read that you can open a notepad in excel with vba and that you can copy contents of the notepad into a string/range. is that possible?
I want to create a macro that will help me open a target file (open as notepad), maybe copy contents to a string.
Because what I really want to do is search through the contents of the text file, and copy a certain string.
the text file contains such dataexample)
MIDlet-Name: Helloword
MIDlet-Version: 1.1.0
MIDlet-Vendor: MyHouse
I want to be able to get the value for "version" or 1.1.0 and copy it to a cell.
Any inputs will be really appreciated. thanks!