Yes, the userform writes to the Excel table and closes it, then calls up the Word template that executes the SQL query. The userform in itself DOES NOT open the table.
The catch is that the UF worked perfectly well until now, and that same routine works well in other similar files. I thought it could be a corruption in the table, so I rebuilt it, but to no avail.
|