Dear Sir/Mam,
I am basic user of VBA code. I have created a macro for sending excel range on email body. I have used Mailenvelope method to fullfill my need. It was working fine till last month. Now while running the code I am getting an error.
Runtime error '-2147319779 (8002801d)': method...
Thank you once again....
This code is not running as per my requirement. In source folder i have multiple text file.
the code which you have provided is taking only one file at a time. and it not splitting a text file into csv. with keeping 14 records in each csv.
Thanks Deb.
Thanks Deb for reverting.
by using your macro it combine all text file in single csv file. Where as i need a macro in which macro can create a csv which contains only 14 records from text file. i.e. if a text file contains 28 rows (record) then there should be 2 csv file containing 14 record...
Thank you sir,
It is just file which contains the sample data as given below
"Abcdef|0000000000000|000000|0|NA|NA|0000000000000000|000000000|00000000|00000000|NA|0000000000|Rocky|NA"
Some files having 14 row or some have rows more than 10000. My concern is that want create a csv file with 14...
Hi All,
I am Vaibhav from Mumbai. Want to become active member chandoo.org. Coz my interest is Excel.
And Thanks to this forum everything is available is here....
Regards,
Vaibhav
Hi Friends,
I am new to this group. Need your help to do a task (which very hard for me)
My question as follows.
I have multiples of text files which I need to convert in “csv” file but conditions is that while converting “txt” to “csv” the “csv” file must contains only 14 records (rows)...