Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting Environment Variables into Cells
Hi,
I can't seem to figure out the simple code to put environment variables into the cells of my choice with the click of a command button. This is about as far as I got: Private Sub Inert_Variables_Click() ActiveCell = Environ("windir") End Sub I don't really want to use the activeCell object if I don't have to. Is there a simple way like telling it which individual cells I want to insert the different variables into like: Cell A3 = Environ("windir") Cell B7 = Environ("winbootdir") Cell D4 = Environ("userprofile") etc... I really don't know where else to ask for help on this. There has got to be a really simple way to do this. Please help. Thanks, Kevin Hunter Fabrication Specialist |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
System Environment Variables | Excel Discussion (Misc queries) | |||
System Environment Variables | Excel Discussion (Misc queries) | |||
inserting variables in code???? | Excel Programming | |||
How do I use environment variables in Excel? | Excel Programming | |||
Can I use Environment variables (such as %USERPROFILE%) in Excel . | Excel Programming |