by
Published on 2006-09-05 06:22 AM
Number of Views: 84404
I recently had reason to create a database on the fly if one did not exist. Since it took me some trial, error and searching (and then more trial and error,) I decided to share the method to do this. The following routine will create an Access database from any VBA enabled application, such as Word, Excel, Outlook, etc...
...
Knowledge Base Articles By Category
Recent Forum Posts
Conditionally filling a table based on non-unique information from another table
In G4:
AliGW Today, 02:09 PM=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($A$1:$A$13)/($C$1:$C$13="Production"),ROWS($1:1))),"")
In H4:...