Hello All,
Here is my situation, I'm trying to create a compiler program for a project we are working on. We have one department that generates a raw excel file with a ton of data. I have a userform with a few different button. One of the button is for "Importing Raw Data". Now I've been doing research and i can't seem to find coding for what i want. So when the user presses the button, an open window pops up and allows the user to select the excel file required. (Note the raw data is always stored in a new folder and constantly has different file names) Once the user select the excel file. The program will copy over sheet 1 from that file and transfer it to the main program file and rename the sheet "Raw Data".
If anyone can please help me with this. The main program .xlsm file is called "MD Compiler.xlsm".
Thank you for your help.
Here is my situation, I'm trying to create a compiler program for a project we are working on. We have one department that generates a raw excel file with a ton of data. I have a userform with a few different button. One of the button is for "Importing Raw Data". Now I've been doing research and i can't seem to find coding for what i want. So when the user presses the button, an open window pops up and allows the user to select the excel file required. (Note the raw data is always stored in a new folder and constantly has different file names) Once the user select the excel file. The program will copy over sheet 1 from that file and transfer it to the main program file and rename the sheet "Raw Data".
If anyone can please help me with this. The main program .xlsm file is called "MD Compiler.xlsm".
Thank you for your help.