I am finding that VBscript's SendKeys does not support Unicode. It supports some like A-65, but not foreign letters like the letter Aleph (א) from the Hebrew alphabet. Prob outside its supported range. Could be for decimal values of 128+, it gives a "?", and it only supports the ASCII range. I can type and see Hebrew letters on my compu...
I have written a vb script to open a file with different filetype other than the original filetype(eg : from .doc filetype to .txt filetype) below is my code Dim objShell Set objShell = CreateObject("WScript.Shell") objShell.Run("notepad" & "C:\OpenWith_Shell32_Doc.doc") the above code was working fine but one day i edited the 'notep...
Hello, i try to copy the second line from a txt, that works great problem is now i try to make an if-statement that check the txt, is there something in line 2. Set fso = CreateObject("Scripting.FileSystemObject") Set MyFile = fso.CreateTextFile("testfile.txt", True) MyFile.WriteLine("" + LastMessage + "") MyFile.Close rownumber...
Hi, so the following code: Dim objFSO : Set objFSO = CreateObject("Scripting.FileSystemObject") Dim colDrives : Set colDrives = objFSO.Drives Dim objWMIService : Set objWMIService = GetObject("winmgmts:") Dim objLogicalDisk Dim objDrive For Each objDrive in colDrives Set objLogicalDisk = objWMIService.Get("Win32_LogicalDisk.Devic...
I am using the following code but the toolbar button doesnt get accessed at all. The error is "unknown error" Window(window_name).WinToolBar("Example Toolbar").Press "Print" Here Example Toolbar is added to the object repo, and gets highlighted correctly. ...
I want to get the serial number of the boot-harddisk via a WQL query. The boot-partition can be retrieved using the following query: SELECT * FROM Win32_DiskPartition where BootPartition=True The serial number is in Win32_DiskDrive: SELECT DeviceID, SerialNumber FROM Win32_DiskDrive Win32_DiskDriveToDiskPartition has the mapping o...
How to transfer more than 65536 rows from Access to excel 2007. There is no limitaion on the part of Excel 2007 as the new version supports much more than 65536 rows in Excel. Limitation is coming on the part of Clipboard. It is not allowing to export or to Copy more than 65536 rows from Access. Thanks ...
I use the split function of in VBScript to split the string. Below is the code am using. Dim inputText DIM resultArray inputText = "abc; def; ""xyz;123""" resultArray = Split(inputText, "; ") For i = 0 To UBound(resultArray) resultArray(i) = Replace(resultArray(i), """", "") resultArray(i) = Replace(resultArray(i), ...
I'm new to VBscript so there is probably a very simple solution to this. Basically, I have my main page with buttons that really just act as links to other pages. In the links I wanted to pass information, so I use the standard ?variable=value like so: <input type="button" name="saveButton" value="Save Systems" onclick="location.href='...
[Withdrawing question: the issue arose from not escaping values submitted in web form. The ASP script removed unescaped spaces thereby causing the problem.] In a web page I am attempting to conduct a search against a table in MS SQL Server using VBScript. The search uses a LIKE clause (with wildcards). The search works fine if the input...
I have some info saved in a database field with the following structure: First Name: > XXX Last Name: > XXX Sex: Male > Female Age: 19 > 20 This information reflects changes made to a specific database record. In this example, First Name was changed from nothing to XXX, Last Name from nothing to XXX, Sex from Male to Female, and Age f...
Hi, In the Windows scripting API is there any way to move the mouse through similar to the wshell.SendKey() function? Thanks in advance ...
Using Scripting.FileSystemObject I can get the full path name of a file, but this will always be like "c:\temp\myfile.txt". How can I get the name of the PC, or a network-path to the file like \MyPC\temp\myfile.txt? Is there another class other than Scripting.FileSystemObject I can use? ...
I am trying to login to an FTP server from VB script and execute some commands. manually we login to ftp server with: ftp my.server.name Enter Uname: _ Enter Pwd: _ uname and pwd are prompts for the user. How can I do this from VB script? if there was a way to login to a ftp server by supplying uname and pwd in the same line then ...
I need help creating a self extracting zip file that does not display anything. I just need it to extract the files to a given place in the background. Everything I have found displays a dialog, but I need it to just run in the background. ...
I'm not understanding this behavior. Maybe someone can explain to me why my current working directory is not what I expect. On my desktop, I have a folder called STKGui: C:\Documents and Settings\Lauren\Desktop\STKGui Located in that directory are the following files: gui.html, style.css, save.html, load.html Within STKGui there are ...
Hi, If i use DatePart("m",Now()) ' out put will be 7 but my requirment is to display "07" rather than "7" Is there any direct method to achieve this, or should should I write custom code to prefix "0" zero? ...
In my installer I need to do the following: obtain location of the external application from registry and create folders for my application executive and various files in this “parent” directory. I know how to get this directory from registry, but unfortunately the string I get looks like this: C:/Programm Files/Manufacturer/ExtApplicati...
I have written the following code to get all the elements in the combo and check with my required value, but i think there may be a better way. Whats the better method to check if any item is there in a combobox? couldnt get from the QTP help. For check_index=0 to Window(window_name).Dialog(dialog_name).WinComboBox(control_name).GetItem...
I'm getting an "object required" error on line 54, the last line, when I run the following script. What is wrong? Option Explicit Dim cmdString, g_strHostFile, filepath, flexnetpath, importcmd, dtmToday, dtmYesterday, dtmFileDate, param1, param2, param3, i4path, objFSO, objTextStream, g_strComputer, WshShell 'Initialize global constant...