Search results

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

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

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?

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

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

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

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!

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

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

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