VBA Select the excel file for your Vlookup Link

AceandVecky

New Member
Joined
Jun 7, 2019
Messages
3
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 ^^
 

Forum statistics

Threads
1,077,795
Messages
5,336,373
Members
399,077
Latest member
johnk94

Some videos you may like

This Week's Hot Topics

Top