View Single Post
 
Old 05-22-2018, 05:43 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Quote:
Originally Posted by daiwuliz View Post
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.
Reply With Quote