VBA to export a table to CSV/TXT

[BakerUK]

Hi guys

I'm after some VB to simply select a table within an Excel worksheet (not the full worksheet, just the table including it's headers) and output it as either a txt file or a csv.

I did an extensive Google search for this and found loads to try but can't quite get any of them to work - so would really appreciate any suggestions!

The closest I've come outputs to a txt file without any errors but the txt file mysteriously stops midway through row 606 out of 756. There are no unusual characters in the cell it stops at, the txt file size is 297 KB. So I don't know if I've hit some sort of a max limit somewhere?

Hope someone can help!

Thanks

Baker

 

[Johnny C]

This may sound a bit weird, but are you saving directly to a network or to a hosted network elsewhere?

When you export to a hosted network, if bandwidth is limited, it can take 10 mins or more for the full file to come through. I've had that in the past, would sit there scratching my head and then when I came back a while later the full file had appeared.

 

[BakerUK]

Thanks for the response. It's direct to a network so it's not due to connectivity or network speed issues.