by
Published on 2006-09-05 07:22 AM
Number of Views: 69161
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
VBA fill blank cells with value above
Try adding this to the end of your submitComandButton_Click()
'Fill blanks from above For col = 3 To 11 If ThisWorkbook.Worksheets("Sheet1").Cells(lastrow