VBA Export to Text

[rollnation2]

Hello Power Users!

I want to create a macro to export a specific range, in a specific workbook to a .txt file. Then title the .txt file with a name from a cell within the workbook.

Data I want exported to notepad as text:
1.Range: B2:N34 ---> Sometimes this range will be larger, so I would like it to be dynamic, exporting everything in the range (no blanks).
2. I want the name of the .txt file to be what is in cell T2 of the same sheet.

Sheetname: "KTR ERP Upload FY22"

Image attached

Any help is appreciated!!

 

[Fluff]

Duplicate to: VBA to Print Excel Range to Notepad Help

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.