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

[DocAElstein]

Try

' 3b
 Let Application.DisplayAlerts = False
 w2.SaveAs Filename:=w2.FullName, FileFormat:=xlCSV
 'Let Application.DisplayAlerts = False
 w2.Close
 Let Application.DisplayAlerts = True
 
End Sub

[fixer]

Thnx Alot Doc Sir For Ur Great Help
Have a Awesome Day

[DocAElstein]

Avinash

Remember to always please give a link to everywhere else that you post,

……Sorry for not giving a link bcoz i thought no one is working on this problem so Time will not be wasted of anyone
I will take care of the same in future...

Once again you have blatently lied to me and been disrespectful and ignored what we have said to you:
Cross Post:
https://chandoo.org/forum/threads/copy-and-paste.44182/
You are continuing to be disrespectful and annoying all people trying hard to help you.
This is becoming intolerable to everyone.

Alan

Edit Good Grief! Yet another one! https://www.ozgrid.com/forum/index.p...aste/&pageNo=2
So we have, at least
https://chandoo.org/forum/threads/copy-and-paste.44182/
https://excelfox.com/forum/showthrea...ll=1#post13439
https://www.experts-exchange.com/que...-the-file.html
https://www.ozgrid.com/forum/index.p...aste/&pageNo=2
http://www.eileenslounge.com/viewtopic.php?f=30&t=34508

[fixer]

Sorry for the same & this will not be repeated in future

[fixer]

I have not lied it to u
U told me from where u got the solution of that problem then I told u that from experts exchange, I got it & shared u the link also


If u see all the post then U will notice I posted the question but question was not solved by anyone of them except experts exchange & that macro also has some issue if i ran the macro with less data & then again I consider ur code & made some changes by you & problem solved on that day

[DocAElstein]

Avinash
You continually lie , cross post, and ignore what you are asked. If you seriously do not believe this fact yourself, then you should seek medical / psychological help quickly, as you are probably dangerously insane.

---

Sorry for the same & this will not be repeated in future

This you have already said many times here and elsewhere. Like many things you write, it often does not mean what it says… it is a lie.. or you are incapable of keeping your promise.. Or you believe it to be correct/ true, in which case you should seek medical / psychological help quickly, as you are probably dangerously insane.

---

It is very, very simple. So simple that even you can understand it:
Every time you post the same question anywhere, then immediately after tell everybody everywhere of all the cross posts

I have tried to tell you per PM the conditions for me to help you ever again.

If you insult me by
lying ever again,
or not reading anything that I have written,
or not responding as I want,
Then I will ban you immediately. ( And if I ever come to Mumbai in India, then I will find you, and I will beat the fucking shit out of you, Bro! )

Alan

[fixer]

Relax now I understood what u mean to say about .csv
I am seeing error sometime's & now I understood the game

Actually I will let u know what happened
As u know I am present in most of the forum & I ask question in that forum & many coders have done so(they have opened text file by excel,I do not know the exact technical language to describe what they have done)& u r doing something different which was new for me & I got confused

Let the story be xyz, Now I understood the Game & I will not try to play with .csv & I will take ur suggestion before doing anything with .csv files

Today I saw an error while I was uploading the .CSV file to the system
There were 164 stocks but system shown only 3 stocks
& Again I cancelled that & Again I reuploaded the file to system then it showed 164 & system showed the problem as comparator issue for the error

No problem

Till today I was ignoring ur .csv explanation only bcoz I have not got any errors till today but now I got it ,So working on the same

Thnx for ur Great help & Thnx Alot for ur Great Guidance in making the things perfect & Accurate

[DocAElstein]

.... system showed the problem as comparator issue for the error....

So very slowly you may understand something…

Just for your info
Seperated = Delimeter = Comparator

Comma Seperated Values file
=
Comma delimeted Values files
=
Comma comparator files
=
comma delimited files
=
Comma comparator seperated files

etc…

[DocAElstein]

When you give an explanation on a file… Do not do it on a .csv file

Better is to give 2 text files , a before and after
Before.csv
After.csv

Before.csv is the file to use in a macro
After.csv is the file that the macro should give you

---

For forum question:

_1) Write Explanation or question in forum post

_2) Explanation can also be in Excel file

_3) Do not give an explanation in a text ( .csv or .txt ) file

_4) Before and After
_4a) For Excel files you can give Before and After.
It can be two worksheets, SheetBefore and SheetAfter in one Excel File,
or
it can be two Files, like Before.xls and After.xls

_4b) For text files you can give Before and After.
But it must be 2 files ( text files do not have worksheets ), like Before.csv and After.csv

[fixer]

Sure Doc Sir
From Now there will be no.csv files in my Question