Extract numerical value from bmp file using VBA

I've looked at this site. The results are what I am after, but cannot repeat the trick using the code on said website. I guess this has something to do with 64-bit vs 32-bit-compatible code (?).

Surely there must be a simpler way to extract the colour value of a pixel (with given x,y-coordinates) in a bitmap (*.bmp) to a numerical value using Excel VBA -only-, i.e. without using 3rd party software, APIs, or online converters, right...?

So, I know for example the colour of the pixel located (100,100) pixels from the top left corner is red (R = 255, G = 0, B = 0). How do I get that information into a cell on an Excel worksheet?

What is the simplest way to extract the colour value of a given pixel in a bitmap image of any size, colour depth or resolution please?

Originally Posted by Pak Mariman

What is the simplest way to extract the colour value of a given pixel in a bitmap image of any size, colour depth or resolution please?

No easy way as Excel is obviously not a 'picture' software and as it does not directly work with pixels,
VBA does not have any feature like you can see in your link as all is done via OS features (Windows) …

Originally Posted by Pak Mariman

I guess this has something to do with 64-bit vs 32-bit-compatible code (?).

Maybe … But you forgot to indicate what is your exact Excel version ?

Originally Posted by Pak Mariman

[…] in a bitmap (*.bmp) to a numerical value using Excel VBA -only-, i.e. without using 3rd party software, APIs …

In the case of a .bmp file an idea is to not load the file within a worksheet - useless according to your constraints -
but just reading it in binary mode in order to decode it in memory to a specific data structure
so to follow this way you must first investigate on the official .bmp data type structure …