Radarspotting

Mode-S Software => Basestation => Topic started by: egnx on November 18, 2018, 09:44:56 AM

Title: Countries.dat Lookup Tool
Post by: egnx on November 18, 2018, 09:44:56 AM
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]
Title: Re: Re: Countries.dat file for Basestation
Post by: Anmer on November 18, 2018, 09:58:10 AM
Thanks Kelvin, works just fine.
Title: Re: Re: Countries.dat file for Basestation
Post by: Truetrack on November 18, 2018, 11:57:11 AM
Great tool !

Thank you
Title: Re: Re: Countries.dat file for Basestation
Post by: Triple7 on November 18, 2018, 05:27:35 PM
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
Title: Re: Re: Countries.dat file for Basestation
Post by: Anmer on November 18, 2018, 05:30:49 PM
Hi Tim.

Did you save and extract the Zip file?
Title: Re: Re: Countries.dat file for Basestation
Post by: Triple7 on November 18, 2018, 05:32:24 PM
Yes Mike, I did. Error pops up as soon as the file opens.

EDIT: Screen grab attached

Tim

[attachment deleted reduce file load]
Title: Re: Re: Countries.dat file for Basestation
Post by: Anmer on November 18, 2018, 05:37:56 PM
Thanks Tim.

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

Try that.
Title: Re: Re: Countries.dat file for Basestation
Post by: Triple7 on November 18, 2018, 05:39:40 PM
Each time I click on any of the buttons - the error message re-appears.

Tim
Title: Re: Re: Countries.dat file for Basestation
Post by: Anmer on November 18, 2018, 05:53:09 PM
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]
Title: Re: Re: Countries.dat file for Basestation
Post by: Triple7 on November 18, 2018, 06:17:56 PM
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]
Title: Re: Re: Countries.dat file for Basestation
Post by: Anmer on November 18, 2018, 06:21:37 PM
Sorry Tim, can't offer any suggestions.

I assume the spreadsheet's not compatible with Office 365.
Title: Re: Re: Countries.dat file for Basestation
Post by: Triple7 on November 18, 2018, 06:26:52 PM
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
Title: Re: Re: Countries.dat file for Basestation
Post by: Anmer on November 18, 2018, 06:32:45 PM
Hi Tim

I've just emailed you a copy of my unprotected Excel file.
Title: Re: Re: Countries.dat file for Basestation
Post by: Triple7 on November 18, 2018, 06:40:21 PM
The module (VBA code) is still password protected though!

Tim
Title: Re: Re: Countries.dat file for Basestation
Post by: egnx on November 20, 2018, 07:16:43 AM
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]
Title: Re: Re: Countries.dat file for Basestation
Post by: Triple7 on November 20, 2018, 07:50:34 AM
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]
Title: Re: Re: Countries.dat file for Basestation
Post by: Anmer on November 20, 2018, 08:15:12 AM
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.
Title: Re: Re: Countries.dat file for Basestation
Post by: egnx on November 20, 2018, 09:09:01 AM
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]
Title: Re: Re: Countries.dat file for Basestation
Post by: Triple7 on November 20, 2018, 09:14:09 AM
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
Title: Re: Countries.dat Lookup Tool
Post by: egnx on November 20, 2018, 12:22:24 PM
No problem, pleased to hear it is now working for you as well.

Kelvin