Regardless of how you end up with lots of open workbooks, closing them all manually, one by one, can be tedious. The good news is that you can use a VBA procedure to shut them all instead.

I would like to take an existing text file (approx 4 megs in size) and manipulate it with VB or VBA (from inside Access in that case) and then ideally place it inside a table format, at the very ...

First off, I am not a VB programmer. At my office one of our employees needed an update to an old program they use to update an Access database. The user has a form that lists different fields ...