I have a macro that I use that copies part of the active worksheet, opens an existing workbook, pastes the stuff copied. The newly opened workbook then does some calculations based upon what is pasted. Then it copies the results back into the original workbook.
Problem is the workbook that I open from the macro sometimes changes names or location. How do I create an input messagebox that promts the user to choose the location of the file?
Thanks!
Problem is the workbook that I open from the macro sometimes changes names or location. How do I create an input messagebox that promts the user to choose the location of the file?
Thanks!