Countries.dat Lookup Tool

[egnx]

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]

[Anmer]

Thanks Kelvin, works just fine.

[Truetrack]

Great tool !

Thank you

[Triple7]

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

[Anmer]

Hi Tim.

Did you save and extract the Zip file?

[Triple7]

Yes Mike, I did. Error pops up as soon as the file opens.

EDIT: Screen grab attached

Tim

[attachment deleted reduce file load]

[Anmer]

Thanks Tim.

The Search feature is on the second worksheet.  The one labelled "Search".

Try that.

[Triple7]

Each time I click on any of the buttons - the error message re-appears.

Tim

[Anmer]

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]

[Triple7]

Are you definitely using the Search worksheet?

I am!

Tim

[attachment deleted reduce file load]

[Anmer]

Sorry Tim, can't offer any suggestions.

I assume the spreadsheet's not compatible with Office 365.

[Triple7]

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

[Anmer]

Hi Tim

I've just emailed you a copy of my unprotected Excel file.

[Triple7]

The module (VBA code) is still password protected though!

Tim

[egnx]

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]