SpielbergRules247465
New Member
- Joined
- Jun 22, 2020
- Messages
- 4
- Office Version
- 2019
- 2007
- Platform
- Windows
I searched this forum and Google and cannot find anything that doesn't also mention Google sheets for some reason.
Anyway, I have an open workbook.
Through VBA, I need to open an XLS file for further processing.
The processing part is easy.
Getting the file to "import" I cannot figure out.
On the VBA UserForm, the file name isn't known until the user selects it, so a variable will need to be included in the code.
I tied just opening the sheet, witching to it, copying the data, creating a new sheet in the open one, but that didn't work.
Then I tried moving that sheet to the open workbook That didn't work either.
I am surprised this is so complicated (for ME.)
So, can one of you absolute gurus tell me, through VBA, to open the XLS file right into the existing workbook?
Thank you all in advance for your amazing genius!
Anyway, I have an open workbook.
Through VBA, I need to open an XLS file for further processing.
The processing part is easy.
Getting the file to "import" I cannot figure out.
On the VBA UserForm, the file name isn't known until the user selects it, so a variable will need to be included in the code.
I tied just opening the sheet, witching to it, copying the data, creating a new sheet in the open one, but that didn't work.
Then I tried moving that sheet to the open workbook That didn't work either.
I am surprised this is so complicated (for ME.)
So, can one of you absolute gurus tell me, through VBA, to open the XLS file right into the existing workbook?
Thank you all in advance for your amazing genius!