I tell you now already 101 times… there are no such things as notepad files , notepad data … etc… you mean text filesOriginally Posted by fixer
Biggest Problem is not text files
Excel files sometimes have problem. Excel files sometimes have no problem
Text files sometimes have problem. Text files sometimes have no problem
It makes no difference to use only Excel , or only text, or both. Problems remain the same
Using Excel to manipulate text is mostly no problem if you do it properly, like https://www.homeandlearn.org/open_a_...le_in_vba.html
To open in Excel or to save a file from Excel to text can give problems often.
It makes no difference for Avinash to use text files or Excel files
You do not understand VBA or Excel or text files. This is a problem. It makes no difference if you use text or Excel. This is a problem, but not the biggest problem..
Biggest problems are
_ Avinash does not understand English
_ Avinash replies too quickly, does not read or understand, and makes mistakes
So we all waste lots of time
Example
We wasted a whole day because
_ Avinash did not understand this:
____ Upload the file that gives you the error
_ Avinash made mistakes and uploaded wrong files
That was big problem.
The problem with the macro was very small.
I am not really sure ahat you mean, but
Biggest problems are from converting/ changing from text ( .csv ) to Excel or Excel to text etc..
Excel files should stay Excel files
Text files ( .csv) should stay text files.
My macros, ( and jindons macros ) have Excel file stay as Excel File, Text file stay as text file.
No changing or converting Excel to text, text to excel
This is best.
( I do not have anymore time for you today. I look again tomorrow
)
Reply With Quote
Bookmarks