VBA Select the excel file for your Vlookup Link

AceandVecky

New Member
Joined
Jun 7, 2019
Messages
4
Hello Guys. Please help me with my little Project.
I have this project where i needed to link a database(Process2.excel) to another database(Process1.excel) so that it can automatically compute the offset adjustment(CNC Machinining) based from the Part ID's data from the previous process. The thing here is that I want to have a Macro Button that will allow the user to select the specific file from where the Vlookup should refer to.

What i cannot do is manipulate/change the External Link of Vlookup through VBA code.
Sorry for my being Newbie.. Hope you guys would help... Thanks a lot ^^
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Watch MrExcel Video

Forum statistics

Threads
1,095,515
Messages
5,444,897
Members
405,305
Latest member
Furqan khan

This Week's Hot Topics

Top