maybe someone else can post a code for that, it doesn't take long. Start
from mine, improve it...
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help,
Hi Ganesh
I have currently too little time until end of week to look at your query.
Just check that everything is on C: path drive and that a folder merge
exist on the same location.
Else, I'll have to look closer.
Regards
Pascal
--
Join official Facebook page of this forum @
https://www.fa
Hi Ashish,
Please find attached text files and excel sheet for your reference.
Please let me know if you have any clarifications.
Regards,
Ganesh
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thr
share some sample text files
On Tue, Nov 27, 2012 at 8:21 PM, Ganesh wrote:
> Hi Pascal,
>
> I am not get correct solution from this coding
>
> Please help !!!
>
>
> On Sat, Nov 24, 2012 at 8:11 PM, bpascal123 wrote:
>
>> Another shorter programming solution would have been to autofilter c
Hi Pascal,
I am not get correct solution from this coding
Please help !!!
On Sat, Nov 24, 2012 at 8:11 PM, bpascal123 wrote:
> Another shorter programming solution would have been to autofilter column
> B and copy visible cells into a table and do the same thing and
> let CopyDataToTxtFil
Another shorter programming solution would have been to autofilter column B
and copy visible cells into a table and do the same thing and
let CopyDataToTxtFile do the same thing. am I wrong?
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) U
Hi Ganesh
You can try that
Create a module and copy paste into it
Sub CopyMergeTxtFiles()
With Application
.ScreenUpdating = False
.DisplayAlerts = False
.Calculation = xlCalculationManual
.EnableEvents = False
End With
Dim ws As Worksheet
Dim i As Long, j As Long
Dim lastr As
Hi Pascal,
Your understanding is exactly correct, Kindly help to us.
Thanks & Regards,
Ganesh
>
> On Sat, Nov 24, 2012 at 4:24 AM, bpascal123 wrote:
>
>> Merge1.txt = consist of 1.txt, 2.txt and 3.txt also the same order (1, 2
>> & 3) to copy paste in Merge1.txt file.
>>
>> consist of the con
Merge1.txt = consist of 1.txt, 2.txt and 3.txt also the same order (1, 2 &
3) to copy paste in Merge1.txt file.
consist of the content of 1.txt, 2.txt ... not just what's on the
spreadsheet.
Tell each step of the macro i.e:
1. Open or create a file from path "C:\Merge\Merge1.txt" for the first
Hi Ganesh
Merge1.txt will include 1.txt, 2.txt, 3.txt
Merge4.txt will include 5.6.7.8.txt files
Merge9.txt will include anything from 10.txt file to next Merge.txt ? Plz
confirm
The data in Merge.txt file will be like the content of 3.txt comes after
the content 2.txt and so on?
Pascal
--
Jo
10 matches
Mail list logo
