I've to write a macro in VBA, wherein I would have some text in a notepad in my local drive (in rows and columns format) (same location of notepad every time). After starting the macro, it should pick up the text from that notepad and put in to the excel worksheet. (text in the notepad would be varying, might be two lines, two hundred or thousands or even more). I'm not able to figure out anything that could do this. Any help would be appreciated.
text from notepad into Excel
- Thread starter sach0888
- Start date
Sach0888
Firstly, Welcome to the Chandoo.org forums.
Why not record a macro
Open the notepad in Excel
That will open the import text wizard
Import as appropriate
Select All the data
Copy/Paste into the Excel file
Close the notepad import file
Process as appropriate
Stop recording
Then cleanup and add to your VBA
Firstly, Welcome to the Chandoo.org forums.
Why not record a macro
Open the notepad in Excel
That will open the import text wizard
Import as appropriate
Select All the data
Copy/Paste into the Excel file
Close the notepad import file
Process as appropriate
Stop recording
Then cleanup and add to your VBA