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

Falko26

Board Regular
Joined
Oct 13, 2021
Messages
99
Office Version
  1. 365
Platform
  1. Windows
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,
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
I would use the Filter function, that way it's always up to date. Something like
Excel Formula:
=FILTER([Book1.xlsx]Sheet1!$G$4:$G$26,[Book1.xlsx]Sheet1!$G$4:$G$26<>"")
 
Upvote 0
Solution

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top