Exporting part of a worksheet to text file using VBA

[MikeFranz123]

Hi,

I'm looking for a way to write only part of a worksheet (cells A10:E150, for example) to a text file.

Any idea?

Thanks

Mike

[Bernie Deitrick]

Select the cells and run the first macro - you can certainly modify this to make it less instrusive....

Please Login or Register  to view this content.

[Olly]

Here's a slightly different approach - I recently had to write some text files in UTF-8 format, and found this method the best:

Please Login or Register  to view this content.

[Tinbendr]

My contribution.

Please Login or Register  to view this content.

[Bernie Deitrick]

I like that - but you could change

Please Login or Register  to view this content.

to just

Please Login or Register  to view this content.

[Olly]

Yes, nice spot, thanks!

[MikeFranz123]

Hi, thanks for all the responses!

Quick question, some of the cells I'm exporting are blanks, does anyone know how I could replace blanks with quotation marks?

Thanks again, much appreciated!

Mike

[Olly]

To display blanks as quotation marks, we can add in a few lines:

Please Login or Register  to view this content.

[apo]

Maybe this too...

Please Login or Register  to view this content.

[MikeFranz123]

Great, thanks managed to get it working! Awesome!

Thanks again to everyone!

Mike