Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel
Previous Topic Next Topic

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

Answer 1 / 2

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!
Report
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
Answer 2 / 2

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!
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!