After seeing several posts recently in this and other forums, I wrote an article about how I deal with NavPane visibility. It is now available for review here. Basically, it provides the code I use to hide the NavPane at run time, and the code I use for linking Access, Excel, and CSV files to a database without causing the NavPane to become visible, as it does when using the TransferXXXX methods.
It took a decade, but I can finally kill FilterOnLoad in mixed environments.
It may be of interest to anyone who has played with the Properties collection like here http://allenbrowne.com/ser-69.html
Expert Comment