VBA Copy Rows From One Workbook To text csv File Based On Count In Different Workbook. Cross Posted Chaos

[fixer]

No Doubt Bro Obviously i am waiting for Alan Sir Only
But i dont want to irritate Alan bcoz he has helped me alot
So meanwhile i am thinking about the different ways to solve the same bcoz if Alan was unable to do the same then i will require a
a different strategy to solve the same

[sandy666]

different way? post#33 - Power Query

[fixer]

No we will solve the Problem with 2 macros
Bcoz we will break the process into 2 pieces one macro to count total no. of rows
& second macro for copy paste to csv
It will be easier to understand & easy to solve

[DocAElstein]

... i am waiting for Alan Sir Only
But i dont want to irritate Alan bcoz he has helped me alot
So meanwhile i am thinking about the different ways to solve the same bcoz if Alan was unable to do the same then i will require a
a different strategy to solve the same

I cannot solve a problem if I do not know what the problem is.
I cannot answer a question if I do not know what the question is.
The problem in helping you is always the same. It is not VBA Excel problem. Problem is you are not English. You do not understand English language. Problem is always you and English language.

You ask Question A - We give Answer A
You ask Question B - We give Answer B
Usually, those are not the answers that you want...
You want Answer F - But you cannot speak English. You cannot understand English. You cannot write English. You do not understand English language.
You try to ask question F. But you fail. You ask any question. You ask always wrong question. You write mostly rubbish.

We must keep trying to guess what you want

---

If you want more help from me – Do all this:
_1) Read this : https://excelfox.com/forum/showthrea...ll=1#post13222
_2) Read this : https://excelfox.com/forum/showthrea...ll=1#post13208
_3) Run macro Sub Step14_DogShit() https://excelfox.com/forum/showthrea...ll=1#post13217

_4) Now tell me what that macro does for you? - What results do you get ?

_.____

You have the whole day , Today , to do this all. Take your time. Do it all. Read it all. Do it slowly. I will not answer any more here today. This is my last post here today.
I will look again tomorrow.

---

If you cannot understand what we write, and if you do not do what we ask, then only God can help you. God can see inside your head. God knows what is your question. We are not God. We cannot see inside your head.

[fixer]

U haven't understood the problem
but u have mentioned something plz see the sample pic of the same Doc Sir
U can run the macro and u can see the output is this the same out put which u get after runing the macro which u mentioned in the pic
No Probelm Doc Sir
i am breaking the process in two parts
1)first macro for counting the rows
2)second macro for copy paste

[sandy666]

the problem is because you trying open csv (result) by double click which is not a proper action
you should import csv with defined delimiter (tab)
with double click, Excel ignore tab as delimiter and you've all data in single column

as i said this is a comma separated values type of file and if you define delimiter in your vba comma instead of tab it will work with dbl click or just import

Alan did his job great with your requirement and you got csv with copied data, but what will you do with this csv (and problems with that) is on your side

regards

[fixer]

sandy sir plz share the complete working code if u know
Bro i am not that much smart in vba
U r giving me the hint
But i dont know much about vba
I am not a Vba coder
My dream is to become a Speculator
& without u I can't create a system & if i am unable to create a system then i cant achieve my dream

[DocAElstein]

My dream is to become a Speculator ...

This will be very difficult for you to achieve your dream if you cannot speak English. In this world, you will not achieve very much if you cannot master the English language!!

---

---

---

The biggest problem remains. You are incapable of communicating with us. You either ignore us, or you do not understand most of what we write and do for you.
You are totally incapable of telling us what you want.
It is impossible for us to understand you, because you can not communicate in English.

---

Sandy is probably getting close to guessing what you want: He is very clever, he can almost read your mind…
Your current question seems to be related to opening a file with Excel.
Your current question seems to be related to opening a text file and displaying it in a particular format in Excel
But I am not sure.
Everything that you write makes no sense in English.

---

For today, I will just try again to explain what is different file types here:
https://excelfox.com/forum/showthrea...ll=1#post13248
https://excelfox.com/forum/showthrea...ll=1#post13247

That is all I am doing for you today

---

This is all that I am doing for you today.
Tomorrow I will look in again to see if you have managed to tell us in English language what you want.

Alan

[sandy666]

I think you got a vba code in the first few posts from Alan
the code generate result with tab as delimiter but you trying to open this csv in Excel by double click not import with defined delimiter (tab)
you got what you want but you didn't say what you want to do after vba generate csv file

you should use this option if you want "open" csv with tab delimiter in Excel
frmt.png

[fixer]

No i want to make it automatic, vba code should do all the work
I will not do any manual work