I am currently fighting with an import from a closed workbook. I am trying to open a closed workbook via from the filepicker and then have it copy all cells from the first sheet into my currently open workbook. once done, close the selected workbook again.
However, I am struggling with switching back and forth from the newly opened workbook and the master one. Anyone mind giving me a hand on making this work properly without having to use the workbook filenames please?
Thank you very much,