Hi I am fairly new to VBA but have used it before for simple Macros. Currently, I am trying to adapt a macro to import multiple XER files into separate sheets in a new Excel workbook. (An XER file is an Oracle Primavera backup file that reads in Notebook like a .TXT but will not open directly in Excel)
So far, I have managed to get the following code to work for a single import, but have not been able to adapt it to import multiple files. Each time I try to add multiple files in the getopenfilename dialogue I seem to get different errors.
Ideally, the macro would import each XER file into a separate worksheet and each worksheet would be named the imported filename. Any help would be appreciated.
Bookmarks