I have a macro to import, and was wondering if there's any way to make it automatically "Next" through all options after selecting the file to import until the user gets to the "New Table or Existing Table" screen? I've tried adding SendKeys commands to the macro, but that doesn't work.

Thanks

Start with the file you want to import, and create an Import File Specification for it. Then, you can create a macro with a step to Transfer Text using that file specification, supplying the name of the file to import (source) and the target or destination.

Note that if the import file ever changes, repeat the process and simply change the specifications to match the new format. Make sure to save it. Then, you are set for the next time.