Excel to Check System settings/requirements

sassriverrat

Well-known Member
Joined
Oct 4, 2018
Messages
655
I have a program that is on a USB drive (iso mounted on usb as .exe from an original CD- no license key needed).

I'd like to have a series of macros that do the following but I have no idea how to get Excel to do much outside of the program itself.

Macro1:

checks system "requirements"- basically I want the macro to return the amount of RAM, type/speed of CPU, HDD total space and space available, and screen resolution in a series of cells, say A1:A10. (amount of RAM can be A1, CPU type A2, CPU Speed A3, etc)

Macro2:

Runs a program who's address is in cell B1, let's say.

Macro3:

Capable of changing the screen resolution

Macro4:

Either capable of changing the IP address and subnet of the computer to a static IP and subnet as specified in B2 and B3
OR
Opens the appropriate windows to put the user right there....

Macro5:
changes the IP back to being dynamic

Macro6:
can excel change the internet options in internet explorer? Namely in:
tools > General > Settings> Browsing History > Select "Every time I visit a webpage" in "Check for newer versions of stored pages" and then click ok>apply>ok and, if opened, close internet explorer again?

Thank you VERY VERY much. the intent of this is to have an "instructions" sheet on the excel sheet that, when opened, can just make all of the necessary system checks and setting-changes- run the program, and then change them back through a series of buttons.
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Watch MrExcel Video

Forum statistics

Threads
1,129,573
Messages
5,637,149
Members
416,959
Latest member
Mohzein

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top