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

[DocAElstein]

now run the macro and see the output
have u got the output as attached in that post(Correctoutput.png)?
Now there are 2 ans of this question
1)Yes(yes is not possible bcoz that macro has issue with pasting of the data)
2)No(If No then correct the macro so that it can provide me the desired result)

This is incorrect
There are 3 possibilities
1)Yes(yes is not possible bcoz that macro has issue with pasting of the data)
2)No(If No then correct the macro so that it can provide me the desired result
3) fixer has understood almost nothing of the issues, and he is almost totally incapable of explain anything, or communicating anything in English.

The answer is 3). The answer is almost always 3)

---

---

I think I am slowly starting to understand the question and issues which you have been trying to explain to us……

On the 27th April, I told you to check this: https://excelfox.com/forum/showthrea...ll=1#post13152
( That macro back then gave you the comma seperated values text file output )
You did not understand or you ignored it. Because you cannot understand us or you ignore us....._
_.....It is now 8th Mai. It is now almost 100 posts later ….

---

The issues is not any macro I gave you.
All macros do what you asked for.
The issue is not saving any file. All files were saved in the format you wanted. ( You have asked for many different formats, all have been given as you asked and all gave correct output. All macros given to you gave the results that you asked for. All gave the correct results. )

Your issue appears to be with opening. ….. On the 27th April, I told you to check this: https://excelfox.com/forum/showthrea...ll=1#post13152

---

Question: ( This is my latest guess at what you are trying to ask for )
I have a comma separated file,( for example, from yesterday, : https://excelfox.com/forum/showthrea...ll=1#post13247
‘CommaSeperatedValues.txt’ : https://app.box.com/s/qcjpeu0vt875513gqawmtoufeba3xb28
‘CommaSeperatedValues.csv’ : https://app.box.com/s/w2barpwasveltam4lutjwijks0zft0vq )

When I open this using Excel, I want the comer separated values to appear across the rows, with one value in each cell. I do not want all the values for one row to go in a single cell.


Answer:
This question is a very common question. There are very many solutions to this. This has been done very many times. It can be done manually in many ways.
It can be done with VBA in many ways.
It is a very easy answer and solution

Here is just one solution :

_1) First you must try to understand the issues , you must try to understand what is csv. Otherwise all solutions will be of no use to you.
CSV, comma separated values files (FYI: CSV )
A comer separated values file is nothing to do with Excel… ( Sandy has already tried to explain this to you many times)
It is a text file. It is just plain text. It can be xxxx.txt or xxxxx.csv.
It can have only plain text. It cannot have any other information. It cannot have any information to tell Excel what to do with it.
Excel may open it in different ways. Your Excel may do that differently to other peoples Excel. ( I already tried to tell you this many times :
https://excelfox.com/forum/showthrea...ll=1#post13150
https://excelfox.com/forum/showthrea...ll=1#post13189 )
( You can change your Excel settings manually, or do other things manually to get the comer separated values displayed as you want them, as Sandy has also already explained )

_2) Macro example to open a comma separated values text file:
For example, here are some test files, from yesterday, : https://excelfox.com/forum/showthrea...ll=1#post13247
‘CommaSeperatedValues.txt’ : https://app.box.com/s/qcjpeu0vt875513gqawmtoufeba3xb28
‘CommaSeperatedValues.csv’ : https://app.box.com/s/w2barpwasveltam4lutjwijks0zft0vq

Here is a macro that will open them : https://excelfox.com/forum/showthrea...ll=1#post13272

( You will need to have the comma separated values text files, CommaSeperatedValues.csv and CommaSeperatedValues.txt in the same place as the file in which the macro is. )

After running the macro , Sub OpenTxtFiles_ValuesToBeSeperatedIntoExcelCells() , the values will be placed in the first worksheet of the file in which the macro is in:
Results After:

_____ Workbook: macro.xlsm ( Using Excel 2007 32 bit )

Row\Col	A	B	C	D	E	F	G	H
1	zyxw123	jhas		rider	roger	anjus	sumanjjj
2	Leonardo	umpsbug	kinjals		tinamishra	kinjal124	WigWam
3

Worksheet: Tabelle1

---

Share ‘macro.xlsm’ : https://app.box.com/s/599q2it3uck3hfwm5kscmmgtn0be66wt
‘CommaSeperatedValues.txt’ : https://app.box.com/s/qcjpeu0vt875513gqawmtoufeba3xb28
‘CommaSeperatedValues.csv’ : https://app.box.com/s/w2barpwasveltam4lutjwijks0zft0vq

---

---

I don’t have any more time for you here today.
Please read carefully this post and my next post, and also the PM I try to send you…

Alan