Recent content by Trekkietracker

The video mentioning XLSPadlock So it has taken 3 years but here is Trekkie Tracker. Up for less than a week and already over 400 downloads! I would love to advertise GDG software for free on my website if you want. Thanks for all your help will all the silly code queries. You can download and...

Hey ricdam… I tried your code and it did not work at all for me just a VB 400 error as soon as I start the export. Currently Anto is helping me with his code which seems to work better!

My vba knowledge is limited and I don’t know where to insert the crucial missing code. For example I don’t exactly know what you mean by “Add the string file here” Where & what is the string file? Also I wanted to use it with “do not allow loading or saving of other workbooks” but this seems to...

I have tried the below code and I cannot get it to work. I am using Excel 2019. I have tried on my project but also on a new spreadsheet with default configurations, sheet names and cell references as written in your original sample macro and I get the same vba 400 error. When I run the macro...

No. This does not solve the problem. The next time you compile as a combined 32/64 exe you have to repeat this procedure again before you can compile. Can you fix this bug?

Yes done this but problem always returns after compiling a combination 32 & 64 exe. I have to recompile my code or the read stream error returns. Problem does not occur if 32 & 64 bit exes are compiled separately.

Ok. I solved the below problem. The problem is if you do a combined 32 bit / 64 bit .exe compile. Then the below problem occurs. If you do one or the other or both separately there is no problem with the original sheet or the vba compiled code. Hope this helps you with your fantastic...

This sub routine CANNOT be renamed because it is triggered on the workbook opening. How do I compile in VBA compiler? What do I paste into the compiler window & what do I put back into the VBA editor in my original spreadsheet before compiling the exe? Private Sub Workbook_Open()...

Yes and I have also figured out I can lock the application to a subscriber’s machine instead of locking the file.

I just found part of the answer - i use the Decrypt save file then copy the data to my master file and then re-compile. The updated compile will include all the shared data but be missing their own personal notes and statistics. So how do I re-encrypt their original file because some of their...

Can we debug, view and edit a user’s saved file if hardware locking was enabled on their personal files? The spreadsheet I am building is a fan club tracking database. Users add information to their version of the master file and save it as their own local file. However every three months...