Search results

We have a desktop Access 2007 app that's split into front-end / back-end components. As well as updating the back-end data, the app creates Excel & PDF documents in a number of sub-folders which exist in the same folder as the back-end. It's quite a complicated data structure and the app has...

I'm using Application.FileDialog(msoFileDialogFilePicker) to enable the user to select an Excel file for processing. It correctly obeys .Filters to restrict the files shown to .xls and .xlsx and if I specify just a folder name terminated by "\" in .InitialFileName that works as required too. So...