Export data to txt file/new sheet (selected header)

Hi,

I like to know how can I export the excel data on the attachement to txt delimited but I only need some data from there.

text data header will be

Name Code Unit Price Detail.Description Detail.Stockqty Discount

Name Code = e3 (column)
unit price = h10 (column)

detail.description =c11&" "&b11&" "&d11 (column)

detail.stockqty = m10 (column)

discount = b4

after running the script, it will create a new sheet so that i can just save it into delimited txt using "save as"

Thanks

for now try this

Please Login or Register  to view this content.

Thanks for the code,
Manage to get it working and also edited some code to suit my txt file.

I like to check also

NameCode UnitPrice Detail.Description Detail.StockQty Discount

how to i create a TAB delimiter?

Print #FileNum, Cells(3, 5).Text & " " & Cells(RowCount, 8).Text & " " & Cells(RowCount, 3).Text & " " & Cells(RowCount, 2).Text & " " & Cells(RowCount, 4).Text
any symbol to use as i try pressing "TAB" but after it save to text file (import to excel back I need to use "SPACE" as delimiter instead of Tab

Can I add my own header into the text file?

Header1 Header2 Header3 Header4 Header5 (each with a tab delimiter)

---------- Post added at 04:02 PM ---------- Previous post was at 03:55 PM ----------

Please Login or Register  to view this content.

I edited the code but after i save it to txt file, I can't import to excel in tab delimiter or space delimiter function

You can substitute " " with ","