This is your choice. But it may not be a good decision…Quote:
Originally Posted by fixer
There are sometimes problems with Excel VBA and Excel Files. There are sometimes not problems with Excel VBA and Excel Files
There are sometimes problems with .csv Files. There are sometimes not problems with .csv Files
No difference. Sometime problems. Sometimes no problems with either. Maybe sometimes different problems.
Excel is good for if you want lots of formats ( like colours ) in worksheets.
Text files are sometimes better for just values.
For Excel Files
.xlsm and .xlsx are sometimes slow and inefficient for lots of values
.xls is sometime a little better
For Text files
.csv and .txt are very similar. Sometimes they are almost the same. Sometimes they are exactly the same.
For lots of just values, ( for no formats like no color ) , text files are better than any Excel files
If you have a system that handles lots of values only, with no cell or spreadsheet formats, then usually they will use text files
Excel VBA is good for controlling Excel Files
Excel VBA is good for controlling Text files
It is just sometimes bad to try to Open a text file into Excel.
To open an Excel file with Excel VBA is no problems usually.
To import data from a text file into Excel is also usually no problem.
This is mostly a problem…
To try
Workbooks.Open ____________.csv
or
Workbooks.Open ____________.txt
These two things are often big problem
