I have a small script in Excel VBA and I'm using a Dictionary object.
I want to print all they key-value pairs how do I do this?
Debug.Print "Key=" & ??? & " Value=" & ???
Short exa...
Helllo All,
I am new to VBscripting, and I would like to import all the contents of a CSV file into an existing spreadsheet. I am using the existing spreadsheet as a formated template, and...
Hello
I need to use VBScript to create a new zip file and zip into it a load of photos.
I am using Windows 2003 Server and do not wish to use winzip unless I have to..
Please advise..
...
Hi EE
I attached the code snipped here:
i try using via Hyperterminal to check balance my prepaid. using ussd at command *124# and its works return msg "OK" then new line " Your Prepaid...
How can I quit the vbscript on error instead of resume next?
I've tried a few variations and nothing works.
I tried:
On Error GoTo Quit
Function Quit()
WScript.Quit
End Function
...
OK I created the following script - it basically reads a list of computer names line by line from a text file pings them to see if they are on the network and returns an IP address and output...
I have many workstations across all four time zones in the 48 states. Some of the workstations have the incorrect zone set, depending on their location. Each location has a local domain contr...
I'm using VBScript to return the current date time in YYYYMMDD HHMMSSSS format. However I need to have 4 digits seconds which is up to milliseconds. How to do it?
Hi guys hope you are well.
Id like to display system information as desktop wallpaper on each server on our network, and was just wondering how you might go about doing this with vbscript.
...
I need to run iperf.exe to measure the network performance on a regularly basis and redirect the results to a text file. The following script will capture the information that I need.
date /...
I'm trying to enable/disable network adapter in a script.
The interpreter I'm using is Windows Script Host.
I'm using the command Win32_NetworkAdapter.Enable()/Disable():
strComputer = "....
Hi Experts,
What is wrong in my code? Why I can't use a variable in the query line? If I put the path directly it works fine.
See my code attached....
Thank You
Does anyone know if it is possible to create an InputBox that contains multiple fields (inputs) on a single input box using VBScript? I'd like to ba able to set three variables using a single...
I am trying to query our LDAP server (not our AD controllers) from a vbscript. We run an LDAP server in parallel with our Active Directory domain, so I would like to be able to query both sou...
Hello,
I'd like to know if one can specify message box size and using vbscript and wsh for an Inputbox using the format InputBox("Available options are:" & VbCrLf & _
etc.......
Thank y...
Hello,
I'm using a recordset to populate an excel workbook. Once that is completed, I want to overwrite the existing file. I don't want to click replace existing file.... The displayaler...
How do you vbs or batch command to delete a registy key that has keys below it. I need to delete the key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSLicensing but it might have 2-3 keys below it ...
I currently have many Macro's written in Excel 2003 that I'm testing in Excel 2007. Most of the macros add chart objects and begin by deleting all of the current charts using - ActiveSheet.Ch...
I am building a logon script with vbscript and have run into a snag. I need to "if current user logging in is a member of a certain group then add these shortcuts. I have the shortcuts mappi...
I am trying to run a .bat file from Task Scheduler in Server 2008. I have set up my scheduled task, given it proper permissions and in the Actions Tab I have chosen "Start a Program." In the P...
Hi all,
I'm trying to build a script that List folder and subfolder Permission and stop at 3 depth of my source Folder.
Here's what i got
I have a spreadsheet in which I need to replace all special characters (e.g., replace ` with S, etc.). The code that I have written when executed with the rem'ed statement operates as expected...
I have got a script to connect to AD and create a user account, that has to run on the server itself. objUser is populated with variables that are gathered earlier in the code.
-----------...
I need to come up with a VBscript to perform the following local functions on a Windows XP SP2+ client:
o- if exist HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\<K...
I am using the following code to try and run a script remotely within my domain that I am an administrator on.
I have restricted to code to run for a specific machine for now until I get it...
