Need macro to get machine name

Is there any way to get the machine name with an Excel macro? I'd even
settle for a simple DOS script that I could launch from the macro.

Thanks,

Barry

msgbox environ("ComputerName")

--
HTH

Bob Phillips

"BCS" <[email protected]> wrote in message
news:[email protected]...
> Is there any way to get the machine name with an Excel macro? I'd even
> settle for a simple DOS script that I could launch from the macro.
>
> Thanks,
>
> Barry
>
>

Thanks Bob! Works like a charm!

Barry

"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
>
> msgbox environ("ComputerName")
>
> --
> HTH
>
> Bob Phillips
>
> "BCS" <[email protected]> wrote in message
> news:[email protected]...
> > Is there any way to get the machine name with an Excel macro? I'd even
> > settle for a simple DOS script that I could launch from the macro.
> >
> > Thanks,
> >
> > Barry
> >
> >
>
>

WOW i like that function.. thank god im still learning new stuff.

anyone know what args this environ function can accept?

Sub listEnviron()
Dim i As Integer

i = 1
While Environ(i) <> ""
Debug.Print i, Environ(i)
i = i + 1
Wend
End Sub

---
Regards,
Norman



<[email protected]> wrote in message
news:[email protected]...
> WOW i like that function.. thank god im still learning new stuff.
>
> anyone know what args this environ function can accept?
>