Hi
the attached excel workbook lets you search a Countries.dat file with a Hex mode S and it will show you all rows with a binary mask match and highlight the row that would be used for the country name.
I hope it might help some of you when making changes to your Countries.dat file.
Regards
Kelvin
Mod Edit. Updated Zip file attached.
See: https://radarspotting.com/forum/index.php/topic,7159.msg40208.html#msg40208
[attachment deleted reduce file load]
Thanks Kelvin, works just fine.
Great tool !
Thank you
I'm getting a compile error - clicking on 'help' takes me here:
https://docs.microsoft.com/en-us/office/vba/Language/Reference/User-Interface-Help/compile-error-in-hidden-modulemodule-name
Compile error in hidden module:
A protected module contains a compilation error. Because the error is in a protected module it cannot be displayed.
This error commonly occurs when code is incompatible with the version or architecture of this application (for example, code in a document targets 32-bit Microsoft Office applications but it is attempting to run on 64-bit Office).
This error has the following cause and solution:
Cause of the error:
The error is raised when a compilation error exists in the VBA code inside a protected (hidden) module. The specific compilation error is not exposed because the module is protected.
Possible solutions:
If you have access to the VBA code in the document or project, unprotect the module, and then run the code again to view the specific error.
If you do not have access to the VBA code in the document, then contact the document author to have the code in the hidden module updated.
This happens as soon as I open the spreadsheet. I'm using Office 365 Pro Plus 64 bit. The module (modCdat) is password protected so I can't diagnose the error.
Any suggestions please?
Thanks,
Tim
Hi Tim.
Did you save and extract the Zip file?
Yes Mike, I did. Error pops up as soon as the file opens.
EDIT: Screen grab attached
Tim
[attachment deleted reduce file load]
Thanks Tim.
The Search feature is on the second worksheet. The one labelled "Search".
Try that.
Each time I click on any of the buttons - the error message re-appears.
Tim
Hi Tim
I'm using 64 bit Windows 7 and Office Professional 2013.
I just did a search, as shown and no errors, just the result.
Are you definitely using the Search worksheet?
[attachment deleted reduce file load]
Quote from: Anmer on November 18, 2018, 05:53:09 PM
Are you definitely using the Search worksheet?
I am!
Tim
[attachment deleted reduce file load]
Sorry Tim, can't offer any suggestions.
I assume the spreadsheet's not compatible with Office 365.
Thanks for your suggestions. I also assume something is incompatible with my version of excel.
If the author could send an unprotected version, I could do some debugging and try and resolve it.
Tim
Hi Tim
I've just emailed you a copy of my unprotected Excel file.
The module (VBA code) is still password protected though!
Tim
Hi,
it was created using Office 2016 and i have also used it with Office 365, so i don't think there is a compatibility issue there.
I assume that when you first opened the workbook and you got the yellow security warning banner you did click on the "enable content" button ?
Attached is version with the VBA password removed.
Regards
Kelvin
[attachment deleted reduce file load]
Hi Kelvin,
Yes, I did indeed click the security warning. Thanks for the unprotected file. I can now see there is (apparently) a compile error and it needs attention for 64 bit systems. Please see screen grab attached.
Thanks
Tim
[attachment deleted reduce file load]
Quote from: Triple7 on November 20, 2018, 07:50:34 AM
I can now see there is (apparently) a compile error and it needs attention for 64 bit systems.
Interesting. I'm running 64 bit here.
I also had two "yellow" warnings.
Enable Editing and Enable Content.
i've removed the 32bit api call from the file locate routine, see if it works for you now ?
Regards
Kelvin
[attachment deleted reduce file load]
Hi Kelvin,
That nailed it! Working as advertised now ;D
Many thanks for your help in sorting this out. Sorry to have been a pain!
Tim
No problem, pleased to hear it is now working for you as well.
Kelvin