Two VBA Functions working fine with Win XP but not working with Win 7

Hi everyone,

I have the following functions, which work just fine with with Win XP but when I transferred to Win 7, they both didn't work:

1- Getting Win Version:

Formula:

Please Login or Register  to view this content.

2- Getting IP Address:

Formula:

Please Login or Register  to view this content.

I hope that you can help me in this case,

Regards,

Are you using the 64-bit Excel/Office?

Hello LoveCandle,

I am looking at this code and have to ask where did you get it. It is a mess. The API call is wrong and there are many synbtax errors in the VBA code. I am working on the corrections right now.

Hello LoveCandle,

Here is the corrected code. This function will return the OS version as a text string.

Please Login or Register  to view this content.

Hi everyone,

I got the code from the following webpage:

http://access.mvps.org/access/api/api0055.htm

Thank you very much for correcting the code.

However, what about IP Address Code??

Please Login or Register  to view this content.

Hello LoveCandle,

Here is the second macro. If the URL is left blank, the IP address for the local computer is returned.

Please Login or Register  to view this content.