Search and Import Files using Modules or Macro

[sharonbl]

How do I search and import or link files using Modules or Macro? I have to prompt the user to enter the pathnames for the 2 files in a input box instead of using the Import and Linked Tables function.
I really hope that u guys can help me with it ...thanks
Your help is greatly appreciated