Output Data from a Userform to a txt file

**jason_kelly** · 12-14-2010, 01:59 PM

Hi There,

I need your help,

at the click of a button, id like to have excel, export the values of my userform to a txt file and open it for viewing.

I have attached the desired txt file layout, and a copy of my userform.

Any help with this is greatly appreciated.

Thanks in advance

Jay

**Leith Ross** · 12-14-2010, 04:33 PM

Hello Jason,

I am not sure if this is a problem for you but some of the entries are quite long and exceed the column widths of your example file. Do you need this file to print out on a page?

**jason_kelly** · 12-14-2010, 04:40 PM

Hi Leith,

You are correct!

The intention and end result of this is to be able to print it out in a neatly fashioned manner.

I was hoping to get it in around the same format, but if unable to then I would be able to settle for something that would at least work.

Thanks a bunch.

Jay

**Leith Ross** · 12-14-2010, 04:57 PM

Hello Jay,

I could wrap the text within the column limits. Would that work?

**jason_kelly** · 12-15-2010, 09:50 AM

Hi Leith,

Sure, would love that!

If you can get it to work.

That would be interesting to see how thats all coded and how its able to come together.

Thanks again for all your help.

Jay