Updating excel from access

Now we’ll import the next sheet in the Excel workbook.

Crystal Long teaches and develops with Microsoft Access, Excel, and Office and specializes in remote training.

I have an excel spreadsheet with kind of folder tree structure in it and what I need to do is to have it populated with names of the files from corresponding folders on a regular basis.

I have lots of different directories and it's quite time consuming so I was wondering if it's possible to create a macro that will extract all the filenames from certain folders after mapping folder names from the spreadsheet with actual folders and sub-folders in my directory.

I would like the queries to be invisible while they are running, but currently the user sees 50 query windows open/close which is ugly.

Is there a way to automatically minimize/hide query windows or disable screen update?

Search for updating excel from access:

updating excel from access-26updating excel from access-68

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “updating excel from access”

  1. If you are an active-duty or retired military service member, you are automatically registered in DEERS, the computerized database tracking all military service members, retirees, spouses, and dependents entitled to TRICARE benefits.