![]() |
#4
|
|||
|
|||
![]()
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. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to highlight lines containing specific words | SixStringSW | Word VBA | 4 | 06-03-2018 03:57 PM |
Trying to import specific data from one spreadsheet to another, without matching rows | Wynka | Excel | 0 | 11-26-2014 09:33 AM |
![]() |
KD999 | Excel Programming | 1 | 07-20-2012 08:58 AM |
![]() |
DivideByZer0 | Excel | 3 | 11-10-2009 05:58 PM |
find - reading highlight - highlight all / highlight doesn't stick when saved | bobk544 | Word | 3 | 04-15-2009 03:31 PM |