automate import of Lotus 1-2-3 files

  • Is there a way to automate importing Lotus 1-2-3 files into Excel? It could be via command line (batch file) or VBA.

    Thanks in advance.

    Oh yeah, not sure which version of either software. I think Excel is 2000 or 2002.

  • Welcome to the Forum!

    Are they all in the same directory? Turn on your macro recorder, and import one by hand. Turn off the recorder and you will have the VBA syntax you need. It will then be relatively easy to apply that to all of the desired files if they are inthe same directory. Use the VBA DIR or FileSearch commands (see help for details). See this thread for an example of cycling through files.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!