Hey Team,
I am looking for the quickest cleanest way to update a list of names in my excel document with VBA automatically when I open the workbook. For example I wrote a code that whenever I open my workbook it automatically opens the source workbook, copies the list of names from it and pastes it into the workbook I just opened. This is caused my program to crash a few times, I'm not sure if its because I am opening another workbook with VBA or what.
Is there a cleaner easier way to update my list of names with VBA automatically without needing to open the source Excel book and copy paste? Maybe I have the list in a text document or something easier on the computer to open with VBA?
Thanks,
I am looking for the quickest cleanest way to update a list of names in my excel document with VBA automatically when I open the workbook. For example I wrote a code that whenever I open my workbook it automatically opens the source workbook, copies the list of names from it and pastes it into the workbook I just opened. This is caused my program to crash a few times, I'm not sure if its because I am opening another workbook with VBA or what.
Is there a cleaner easier way to update my list of names with VBA automatically without needing to open the source Excel book and copy paste? Maybe I have the list in a text document or something easier on the computer to open with VBA?
Thanks,