TU71


I have an Excel spreadsheet that needs to determine if the .NET Framework is installed as well as the path to that install. How can this be acomplished in VBA code




Re: Determine if and where the .NET Framework is installed using VBA

bi-lya


You can use the Registry "HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows \ CurrentVersion \ Uninstall" to determine existent soft. You need to use the API-functions RegQueryValueExString, RegOpenKeyEx and others
I have made this function, tomorrow I will test it (I will use PC without the FrameWork)
Do you still need in it






Re: Determine if and where the .NET Framework is installed using VBA

vtortola

For example check if exists %windir%/Microsoft.NET/Framework/ directory.

Regards.






Re: Determine if and where the .NET Framework is installed using VBA

bi-lya

Hi!

It's good, but if soft isn't installed Also, Windows Sistem may set in different PC on different disks (C, D, E...)





Re: Determine if and where the .NET Framework is installed using VBA

vtortola

%windir% is a environment variable that point to Windows instalation path in this PC.

C:\Documents and Settings\ValerianoSrvr>set windir
windir=C:\WINNT

How a Windows system can be installed in a different PC

Regards.





Re: Determine if and where the .NET Framework is installed using VBA

bi-lya

vtortola, I mean if you will use your code in other computer, it don't work if Sistem was set on disk E:\ or D:\
And I finished and tested my function. It "determine if the .NET Framework is installed as well as the path to that install"





Re: Determine if and where the .NET Framework is installed using VBA

vtortola

Oh! i'm sorry , sometimes i have some problems with my english understanding Stick out tongue

Regards.