bloomingcarrot
New Member
- Joined
- Sep 11, 2014
- Messages
- 4
Hi All. I am VERY new to VBA and limited exposure to Excel. Basically what I would like to do is create a VBA code that I can then assign to a button. What I'd like to happen when the button is pushed is this: a text file is created from cells and prompted to save that file with a filename and to a location.
I would like to export certain cells to a text file. Ideally I'd like it to be formatted at A1, B1, C1 as headers and A2, B2, C2 to come underneath. i.e.
<tbody>
</tbody>
Would look like in the text file:
Name
John Doe
Username
@johndoe
THEN I would like to be prompted to save this text file to a location and allowed to enter a filename.
I really hope this is doable because it would save me so much time!
Thanks so much!!
I would like to export certain cells to a text file. Ideally I'd like it to be formatted at A1, B1, C1 as headers and A2, B2, C2 to come underneath. i.e.
Name | Username |
John Doe | @johndoe |
<tbody>
</tbody>
Would look like in the text file:
Name
John Doe
Username
@johndoe
THEN I would like to be prompted to save this text file to a location and allowed to enter a filename.
I really hope this is doable because it would save me so much time!
Thanks so much!!