Linking two programs to one companion file


#1

I recently purchased XLS Padlock and do not know exactly how to do this.

I have two programs both needing to be linked to the same companion file.

The first program (Item Master Data) needs to open the Excel companion file (Preferred Supplier Data) and paste certain information everytime the Item Master Data program is saved. - PLEASE HELP

The second program uses VLOOKUP from the Preffered Supplier Data file. - This should be doable if only I can get the first part to work.


#2

The sole possibility is to place the companion file outside the two EXE files, in the same folder as the two EXE files. Then you’ll have to use full path references thanks to the VBA extension here: