Cleanest quickest way to copy Data from one source to an excel spreadsheet VBA

[Falko26]

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,

 

[ExcelToDAX]

Power Query

 

[Fluff]

I would use the Filter function, that way it's always up to date. Something like

=FILTER([Book1.xlsx]Sheet1!$G$4:$G$26,[Book1.xlsx]Sheet1!$G$4:$G$26<>"")

 

[Fluff]

@ExcelToDAX It would be more helpful if you actually gave some information.