Its about excel macros

Closed
madhuramji
Posts
2
Registration date
Saturday May 9, 2015
Status
Member
Last seen
May 12, 2015
- May 11, 2015 at 11:01 AM
 Blocked Profile - May 12, 2015 at 05:00 PM
Hello,

I need to saveas some excel cell range as text file how to do it
Any help will be appreciated
Thanks in advance

2 replies

Blocked Profile
May 11, 2015 at 05:02 PM
OK, excel is excel and text is text. Do you know how to start a blank ext file in VBA? Copy the range, copy it to a variable, open a blank text file and paste it, save it. Let us know where you get stuck at. We are not going to author you a turn key solution, but we will help if you get stuck. Let us know where you get stuck!
0
madhuramji
Posts
2
Registration date
Saturday May 9, 2015
Status
Member
Last seen
May 12, 2015

May 12, 2015 at 03:16 AM
Hello
ac3mark
Really I don't know blank ext file in vba
I m new to vba
Thanks for your reply
0
Blocked Profile
May 12, 2015 at 05:00 PM
Sorry that was a typo, it should have been text file!

OK, let us start by learning how to make a filesystemobject.

Read into filesystem objects here: https://www.microsoft.com/en-us/download/details.aspx?id=55979

I have not attempted this in a while, so I am not certain if VBA allows access to that library of objects. Read into it!
0