Try
Code:' 3b
Let Application.DisplayAlerts = False
w2.SaveAs Filename:=w2.FullName, FileFormat:=xlCSV
'Let Application.DisplayAlerts = False
w2.Close
Let Application.DisplayAlerts = True
End Sub
Printable View
Try
Code:' 3b
Let Application.DisplayAlerts = False
w2.SaveAs Filename:=w2.FullName, FileFormat:=xlCSV
'Let Application.DisplayAlerts = False
w2.Close
Let Application.DisplayAlerts = True
End Sub
Thnx Alot Doc Sir For Ur Great Help
Have a Awesome Day
Avinash
Quote:
Originally Posted by DocAElstein
Once again you have blatently lied to me and been disrespectful and ignored what we have said to you:Quote:
Originally Posted by fixer
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
Sorry for the same & this will not be repeated in future
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
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.
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.Quote:
Originally Posted by fixer
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
%D
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
So very slowly you may understand something…Quote:
Originally Posted by fixer
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…
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
Sure Doc Sir
From Now there will be no.csv files in my Question%O