Quote:
Originally Posted by daiwuliz
Can it be done using VBA?
|
Probably.
I myself use VBA in Excel when:
1. I need an UDF when I can't get the result using worksheet functions (like getting name of n'th file of certain type in certain folder);
2. I need an Open event (e.g. to update parameters of ODBC query to same Excel workbook when the workbook is moved or renamed);
3. The Excel workbook is used as tool to read some data from one source of certain format, and to create another file of another format based on read data.
In any other cases, when there will be need for VBA, I will seriously consider Access or SQL Server instead.