Its about excel macros [Closed]

Report
Posts
2
Registration date
Saturday May 9, 2015
Status
Member
Last seen
May 12, 2015
-
 Blocked Profile -
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


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!
Posts
2
Registration date
Saturday May 9, 2015
Status
Member
Last seen
May 12, 2015

Hello
ac3mark
Really I don't know blank ext file in vba
I m new to vba
Thanks for your reply

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!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!