Hello Kioskea users. I hope you're all doing great. Today I have a concern that I'm not able to figure out. Any help will be really appreciated.
I'm creating a macro in excel to copy and paste the values from one workbook into another one. So far it works like a charm but it only works when I have all the files open. How can I make the macro get the values without having the other files opened? So far I have this:
' test Macro
'Copy Values from Source