I think you got a vba code in the first few posts from Alan
the code generate result with tab as delimiter but you trying to open this csv in Excel by double click not import with defined delimiter (tab)
you got what you want but you didn't say what you want to do after vba generate csv file
you should use this option if you want "open" csv with tab delimiter in Excel
frmt.png
Reply With Quote
Bookmarks