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?