VBA Macro to export cells to text file and add extra spaces

Hello,

Is there a way to export cells to a text file, but specify the width of each exported cell? Specifically, say I want it to export 50 characters, and if the cell value only has 20, fill the last 30 with spaces...then do that for every cell I specify, for row 2 and beyond.

Is there an easy way to do that?

Please Login or Register  to view this content.

You will need to change paths, ranges etc as neccessary.

Thank you for the reply, let me try that out.

I got an error when running it:

"Runtime error 438. Object doesn't support this property or method"

Debug pointed to this line:

Set fil = fs.createtextfil("C:\Test.txt")

sorry, typo. Should be createtextfile not createtextfil. Also change the path if you need to.