While in one Excel sheet I would like to read data from another Excel sheet and write it to a text file.
Example of the first sheet:
Sheet_Name File_Name Start_Line End_Line
Sheet1 C:\Test.txt B5 H10 Button
Clicking the button should write Sheet1 cells B5-H10 to C:\Test.txt.
How to do that?
Best Answer
Here's an example of how to handle a text file directly
Note: