M mcl Jul 19, 2005 #1 May I assume the fact no one answered my post means it can't be done in a macro. You know negative replies are useful too.
May I assume the fact no one answered my post means it can't be done in a macro. You know negative replies are useful too.
D Douglas J. Steele Jul 19, 2005 #2 Macros are limited in their ability to work with external dialogs. What you're trying to do would be easy using VBA, though. See http://www.mvps.org/access/api/api0002.htm for a complete sample of how to prompt for a folder name.
Macros are limited in their ability to work with external dialogs. What you're trying to do would be easy using VBA, though. See http://www.mvps.org/access/api/api0002.htm for a complete sample of how to prompt for a folder name.
S Steve Schapel Jul 20, 2005 #3 mcl, I answered you in the original thread, not in the second or third thread.
