Recent content by Almiex

  1. A

    Updating old save files with new versions

    My customer requested an update on a Budgeting tool I wrote using XLS Padlock and VBA. He deleted the old version and downloaded the new version (With updated VBA Code), and it works perfectly when he uses the original file. But when he tries to open his saved file (This has a LOT of data and...
  2. A

    Linking two programs to one companion file

    I was able to get everything to work. Thank you.
  3. A

    Linking two programs to one companion file

    I need help with this as well please… How can I get the program to save over the originals files of both the application and companion files instead of asking me to name the new save file every time?
  4. A

    Linking two programs to one companion file

    The code works when it is still in Exel form, but not when I build and open the secure application. What am I missing?
  5. A

    Linking two programs to one companion file

    Thank you for the feedback. I have the following code that needs to run everytime the Item Master Data program is saved (Please help): Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Application.ScreenUpdating = False Dim wbIMD As Workbook, wbPSD As...
  6. A

    Linking two programs to one companion file

    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...
  7. A

    VLOOKUP from another compiled sheet

    That’s not a bad idea… It shouldn’t be too hard to work around. Only question now is, can I link the same unprotected workbook to both compiled files at once? This will actually work perfectly if I can. Thank you so much for your assistance!
  8. A

    VLOOKUP from another compiled sheet

    The problem is as follows: The Master file has all ingredients listed. It has a matrix where different suppliers’ prices are listed and it pulls the cheapest supplier through. Lots of coding is involved. The Cost Calculator file is for costing of Finished Products for different customers. (the...
  9. A

    VLOOKUP from another compiled sheet

    Thank you for the feedback. I have looked at the guide under 5.1.6 Add Companion Files, but it does not help me. I have one of two options, but cannot figure out how to do either: Vlookup from one .exe file to the other. Upon opening the Calculations.exe, it automatically opens the Master.exe...
  10. A

    VLOOKUP from another compiled sheet

    Hello, I have two compiled files. One of them is a master file where Item Info is stored and can work independently. The other is a Cost Calculator with recipes for cosmetic products that retrieves the ingredient info from the Master file. The Costing file can be saved per customer, but must...
Back
Top