Description:
Microsoft scripting newsgroup.
|
|
|
Import CSV file`s to MS-Access
|
| |
Can anybody help me with this script or another script. This script create a ms-access database and 1 table, it also create 2 rows of data. But the problem is i want import a csv file to ms-access with this script. Johan Here is the script : Option Explicit ' On Error Resume Next Dim objDBE, objADO, strSQL... more »
|
|
How to use vbscript to send email
|
| |
The following code ,in my private script library,worked well with another smtpserver which is not available now. However,I find it not work well. It said that "server denied one or more recipient address" I don't how to correct it . Set objEmail = CreateObject("CDO.Message") objEmail.From = "ot...@gmail.com"... more »
|
|
batch file to display ip address when rollover clock
|
| |
hi guys/gals, i am very new to batch scripting and was wondering how would i go about creating a batch file to display a pc ip address and a message when the mouse rolls over the clock area of the task bar? thanks in advance
|
|
vbs with input parameter,
|
| |
Hi All Why my home computer can not check input parameter ? In office below coding is work. Try set as wscript //H:cscript dim objArgs , iArg Sub help wscript.echo("Help") wscript.quit End Sub Set objArgs = WScript.Arguments For iArg = 0 To objArgs.count - 1 if objArgs(iArg) = "-h" then call help... more »
|
|
Find Mac address first, then get IP address and map printer using
|
| |
Guy, Problem: I was assign a task for DR (Disaster Recovery). Lets say our print server goes down for a few hours, I need to find a way to map computers by IP address. The problem is that our printers are on DHCP so if the ip changes then I will be unable to print. Solution (I hope): How can I use vbscript and Win32_NetworkAdapterConfigurat ion or arp to get... more »
|
|
Application.OnTime Not Working
|
| |
I have created the following VBS code: MyTest Set objExcel = CreateObject("Excel.Applicatio n") MsgBox "Before OnTime" objExcel.Application.OnTime Now + TimeValue("00:00:05"), "MyTest" MsgBox "After OnTime" Sub MyTest() MsgBox "MyTest" End Sub The first thing I see is "MyTest", verifies Sub MyTest() is working.... more »
|
|
Internet Explorer object in 64 bit systems
|
| |
I often use the InternetExplorer object in my scripts. [ Set IE = CreateObject("InternetExplorer .Application") ] I have just installed Windows 7 x64 and made an interesting discovery. Even though the default browser used by the system for internet browsing is the 32 bit version of IE, my scripts use the 64 bit version. I... more »
|
|
Problem with date formatting
|
| |
I have created a vbsript that runs from a batch file when users logon to our domain. In the script the date & time of a file on our server is checked & added to a mysql database along with other info. We are in the UK & have our date set to UK format, so in order to get the date into mysql I have to transpose it into yyyy-mm-dd; this works fine for... more »
|
|
Logon script
|
| |
Making a logon script for two locations and want the script to understand what location is logged on to. I can determen this with %logonserver% but is there any properties in vb script that gives me the same function? Or any other suggestions. -T
|
|
Getting a VBS to run every second without it completely frying a server
|
| |
Hi everyone, I don't often do a lot of VBS work, but in this case I need to be able to schedule a task within Windows and the code was already largely written in ASP before I got there, so to port it to VBS was the most logical thing to do. Basically, what I want to do is run a VBS every second to process... more »
|
|
|