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