How to use System Environment Values like %Path% or %Computername% in Form Fields?

C

Christoph Sbach

Example:

Set objCurrentFolder = Application.ActiveExplorer.CurrentFolder
set CurrentItem = objCurrentFolder.Items.Item(1)
CurrentItem.UserProperties.item("Computername").Value=
CurrentItem.UserProperties.item("Username").Value=

Y:\>set
COMPUTERNAME=PC-F110-1
ComSpec=C:\WINNT\system32\cmd.exe
OS=Windows_NT
USERNAME=HannibalL
:
 
C

Christoph Sbach

This resolve my problem:

in vba i create a sub MyShell with shell command inside.

in vbs run this macro with Application.MyShell.



OL2000: Calling a VBA Procedure from VBScript

Anwendbar auf

This article was previously published under Q221827
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a Report using values form multiple combo boxes 2
Use Public Function UserName to populate Form field and bind it to table 4
How Do I use something like Environ(username) in VBA ? 4
unknown exception error in Exchange Environment 3
Using Environment Variables 6
Percent of a value within all values, within a pivottable 8
Office 2007 Compatibility Pack SP1 administrative install 0
InfoPath/sp 2007 Task list Assigned to field value issue 6

Top