Hi,
I have VB Code that convert data in txt file, and its work fine but I need some changes on it.
1. convert only selected row
2. choice of selection where to save file.
Test file attached here..
Thanks in advance
Hi,
I have VB Code that convert data in txt file, and its work fine but I need some changes on it.
1. convert only selected row
2. choice of selection where to save file.
Test file attached here..
Thanks in advance
My English is very poor, so please be patient >_<"
Thanks & Regards.
hkbhansali
Hi Bhansali,
Try Below Code
Please Login or Register to view this content.
Hi mohan.r1980,
Your code not work, its copy row in txt file transpose. and can't select where to save file
Hi Bhansali,
this code is very fast for output if you add the save choice this will reduce the speed, i think it is better to make a specific folder where output will save.
like
rest is as bellowPlease Login or Register to view this content.
Please Login or Register to view this content.
Hi mohan.r1980,
Your Code work from first rows,
ie : if I select rows "A7,A8,A9,A10" and run macro, it's copy in txt file rows "A1,A2,A3,A4"
Is your test file representative? There is only data in column A. If so, this can work.
Please Login or Register to view this content.
Otherwise place a representative example.
Hi Vraag en antwoord,
Yes, My test file is representative,
Your code works fine but its replace with "|" , when I want "," (coma deliminated) and also end of row "|" missing.
Please Login or Register to view this content.
Hi Vraag en antwoord
Thanks a lot...it's work perfect...
is it possible that can browse by option that where to save File?
Last edited by hkbhansali; 07-29-2018 at 08:08 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks