Search Results

Search found 518 results on 21 pages for 'vbscript'.

Page 5/21 | < Previous Page | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >

• How to read CSV files line by line in VBScript

  - by Shyju

  I am using an ASP page where I have to read a CSV file and insert it into DB table "Employee". I am creating an object of TestReader. How can I write a loop to execute up to the number of rows/records of the CSV file which is being read?

  Read the article

• facing problem copying files through xcopy using vbscript

  - by sushant

  i am using the following code. the problem is that folder location path has to be entered by user. assuming i put that path in a variable say "h", how do i call this variable in xcopy. here is the code i tried. please tell the correct syntax. Dim WshShell, oExec,g,h h="D:\newfolder" g="xcopy $h D:\y\ /E" Set WshShell = CreateObject("WScript.Shell") Set oExec = WshShell.Exec(g) i also tried "&h" but it did not work. any help is appreciated and sorry again, i dont know how to format it.

  Read the article

• VBscript and CMD writing into a text file

  - by Effected

  I am writing a script that executes and write everything to the file here is example, I stored the complete command in the variable 'Command' , Command = "ftp ftp.xyz.com 21 " & vbCRLF and then executing it in command prompt, shell.Run "%comspec% /c FTP " & Command & " > " & E:/abc.txt, 0, TRUE but when this program execute it won't write anything to the text file because this is an incomplete command, this command on execution prompt user to input username and password of FTP, how can i do this , that my programm automatically input username and password when prompt and then write everything to file ?

  Read the article

• How to call DLL function in vbscript

  - by amritad

  I am writing VB script in which I have to call a function of a COM DLL. The fuction which I want to use is in structure and thus I want to create the object of that structure to access the required function. e.g. I have a dll 'BasicCom.dll', in which struct abc { bool xyz(); } Now I want to call xyz(). Is any one have any idea, how to deal with such call in Vb script.

  Read the article

• Enumerating Environment keys with VBScript?

  - by Stabledog

  I need to enumerate the keys in the WScript.Shell.Environment object. It's clear that if you already know the name of the key, you're home free with: Set oShell = WScript.CreateObject("WScript.Shell") Debug.WriteLine "PATH=" & oShell.Environment("PATH") ...but if you want to list the keys, it looks like you're out of luck! Is there a secret passageway somewhere?

  Read the article

• Error Expected Loop VBScript

  - by Yoko21

  I have a script that opens up an excel file if the password provided is correct. If its wrong, it prompts a message. It works perfectly when I add a loop at the end. However, the problem is whenever the password is wrong the script won't stop asking for the password because of the loop. What I want is the script to quit/close if the password is wrong. I tried to remove the loop and replaced it with "wscript.quit" but it always prompts the message "expected loop". Here is the code I made. password = "pass" do ask=inputbox ("Please enter password:","DProject") select case ask case password answer=true Set xl = CreateObject("Excel.application") xl.Application.Workbooks.Open "C:\Users\test1\Desktop\test.xlsx" xl.Application.Visible = True Set xl = Nothing wscript.quit end select answer=false x=msgbox("Password incorrect... Aborting") loop until answer=true Is it possible to put a message like that counts when aborting. like "Aborting in 3.... 2... 1".

  Read the article

• VBScript file open dialog that works in XP and Vista?

  - by codeulike

  In XP, you can use VBScript with the UserAccounts.CommonDialog object to bring up a File Open dialog (as described here), but apparently this does not work under Vista. Is there a VBScript method for File-Open dialogs that will work for both? Or even one that will work nicely for Vista? Disclaimer: I'm a proper programmer, honest, and don't usually work with VBScript - I am asking this question 'for a friend'.

  Read the article

• How to convert many thousands of lines of VBScript to C#?

  - by Ross Patterson

  I have a collection of about 10,000 small VBScript programs (50-100 lines each) and a small collection of larger ones, and I'm looking for a way to convert them to C# without resorting to by-hand transliteration. The programs are automated test cases for a web application, written for HP/Mercury's QuickTest Pro, and I'm trying to turn them into test cases for Selenium. Luckily, the tests appear to be well-written, using a library of building blocks and idioms (the larger programs), so the test cases actually resemble a domain-specific language more than they do VBScript, and the QTP-ness is well-buried inside the libraries. Ideally, what I'm searching for is a tool that can do the syntactic transformation from VBScript to C# for both the dsl-ish test cases and also the more complicated building-block libraries. That would leave me with a manual cleanup of the libraries, and probably very little work on the test cases. If I could find a VBScript-to-VB.NET translator, I'd take that also, as I suspect I could compile the VB.NET and then de-compile to C# using .NET Relector or something similar. Plan B is to write a translator of my own for the test cases, since they're in a very straight-line style, but it wouldn't help with the libraries. Any suyggestions? I haven't written a compiler in at least 15 years, and while I haven't forgotten how, I'm not looking forward to it - least of all for VBScript!

  Read the article

• How to suppress the word VBScript in message box title?

  - by Mini

  "Vbscript" always appears in my message box titles. How do I supress it in VbScript code?

  Read the article

• Can I use a VBScript file as a Windows 7 screensaver?

  - by ændrük

  I'd like to use a VBScript file as a screensaver in Windows 7. I have tried setting the following in the registry: [HKEY_CURRENT_USER\Control Panel\Desktop] "ScreenSaveActive"="1" "ScreenSaveTimeOut"="10" "ScreenSaverIsSecure"="0" "SCRNSAVE.EXE"="%PROGRAMFILES%\\myscript\\myscript.vbs" and [HKEY_CURRENT_USER\Control Panel\Desktop] "ScreenSaveActive"="1" "ScreenSaveTimeOut"="10" "ScreenSaverIsSecure"="0" "SCRNSAVE.EXE"="%WINDIR%\\System32\\cscript.exe %PROGRAMFILES%\\myscript\\myscript.vbs" but nothing seems to happen after the timeout. What is the correct way to set this up?

  Read the article

• Is there any free/opensource vbscript to exe converter?

  - by suhair

  I need to convert a wmi vbscript to exe (to automate configuration in several computers). Any free vbscript to exe utility or any other suggestions?

  Read the article

• What's the correct way to pass parameters from VBScript to COM interface implemented in C#?

  - by nopopem

  I'm trying to expose a fairly simple C# class to COM which should be usable from VBScript (among others). Some objects need to be created via COM calls and will be used in furter calls later on. The definition of the exposed classes and interfaces looks like this: namespace Test { [InterfaceType(ComInterfaceType.InterfaceIsIDispatch)] public interface IComInterface { IFoo CreateFoo(); void UseFoo(int x, IFoo f); } [ClassInterface(ClassInterfaceType.None)] public sealed class CComInterface : IComInterface { public CComInterface() {} public IFoo CreateFoo() { return new Foo(); } public void UseFoo(int x, IFoo f) { f.Bar(); } } [InterfaceType(ComInterfaceType.InterfaceIsIDispatch)] public interface IFoo { void Bar(); } [ClassInterface(ClassInterfaceType.None)] public class Foo : IFoo { internal Foo() {} public void Bar() {} } } The simplest thinkable COM client in VBScript does this: Dim ci Set ci = WScript.CreateObject("Test.CComInterface") Dim foo Set foo = ci.CreateFoo foo.Bar ci.UseFoo 0, foo While the call to Bar succeeds, calling UseFoo fails with "Error 5: invalid procedure call or invalid argument" The generated IDL seems ok to me: dispinterface IComInterface { properties: methods: [id(0x60020003)] IFoo* CreateFoo(); [id(0x60020004)] void UseFoo( [in] long x, [in] IFoo* f); }; The vbs call succeeds when I wrap the second parameter in parentheses like this: ci.UseFoo 0, (foo) As far as I understand (I'm no VBScript expert however) this forces the reference to foo to be passed by value, i.e. a copy of the reference is being made. How can I change the interface so that it can be called with the foo reference directly? Since this will be a public interface used by customers I don't like the idea of having to explain why all the objects created need to be passed back in an extra pair of parentheses...

  Read the article

• How to access data using VBSCRIPT from a stored procedure which contains values in Temp table ?

  - by Srivigneshwar

  Hi , for testing purpose I wrote a VBscript which will fetch values from Sybase by executing a stored procedure which contains values in temp table. When I run the script I get the following errors , "Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record." or "Item cannot be found in the collection corresponding to the requested name or ordinal." Somewhere when I was googling I found that , the above error message will be shown when we use temp table in stored procedure, if that is the reason , then how can I access data via VBscript by executing the stored procedure ??

  Read the article

• Is there an alternative of using a VBScript for enabling FileStream after SQL Server installation?

  - by user193655

  To use Filestream on a DB 3 steps must be done: 1) enable it a server/instance level 2) enable it (sp_configure) at DB level 3) create a varbinary(max) field that supports filestream (2) and (3) are done easily with T-SQL (1) is doable manually from SQL Server Configuration Manager, basically what I need is to check all the 3 checkboxes: but how is it possible to automize it? I found this artcile "Enabling filestream usin a VBScript", is there another way to do it than using VBScripts? May be something that is possible to do only with 2008R2? In case it VBScript is the only solution, which are the possible downsides?

  Read the article

• how to manipulate command line through vbscript. i want to execute certain set of commands on cmd pr

  - by sushant

  if anyone could give me a code to access commandline through vbscript.

  Read the article

• Is it possible to get CCM Updates Schedule using Powershel or VBScript?

  - by frogman

  I want to be able to check the CCM Updates Schedule as seen in Configuration Manager Updates tab. I've been looking around on google and I've not been able to find a consistent answer to this. I tried to create a COM object using UDA.CCMUpdatesDeployment. This allows me to successfully set the recurring schedule with SetUserDefinedSchedule method. If I try to use GetUserDefinedSchedule I only get the original values of the variables. PS> $UD = New-Object -com "UDA.CCMUpdatesDeployment" PS> $A= 101 PS> $B= 102 PS> $UD.GetUserDefinedSchedule([ref]$A, [ref]$B) PS> $A 101 PS> $B 102 PS> $UD.GetUserDefinedSchedule MemberType : Method OverloadDefinitions : {void GetUserDefinedSchedule (Variant, Variant)} TypeNameOfValue : System.Management.Automation.PSMethod Value : void GetUserDefinedSchedule (Variant, Variant) Name : GetUserDefinedSchedule IsInstance : True I actually want to be able to do this remotely for a list of servers in a text file but right now any way would do.

  Read the article

• How do I associate Parameters to Command objects in ADO with VBScript?

  - by Krashman5k

  I have been working an ADO VBScript that needs to accept parameters and incorporate those parameters in the Query string that gets passed the the database. I keep getting errors when the Record Set Object attempts to open. If I pass a query without parameters, the recordset opens and I can work with the data. When I run the script through a debugger, the command object does not show a value for the parameter object. It seems to me that I am missing something that associates the Command object and Parameter object, but I do not know what. Here is a bit of the VBScript Code: ... 'Open Text file to collect SQL query string' Set fso = CreateObject("Scripting.FileSystemObject") fileName = "C:\SQLFUN\Limits_ADO.sql" Set tso = fso.OpenTextFile(fileName, FORREADING) SQL = tso.ReadAll 'Create ADO instance' connString = "DRIVER={SQL Server};SERVER=myserver;UID=MyName;PWD=notapassword; Database=favoriteDB" Set connection = CreateObject("ADODB.Connection") Set cmd = CreateObject("ADODB.Command") connection.Open connString cmd.ActiveConnection = connection cmd.CommandText = SQL cmd.CommandType = adCmdText Set paramTotals = cmd.CreateParameter With paramTotals .value = "tot%" .Name = "Param1" End With 'The error occurs on the next line' Set recordset = cmd.Execute If recordset.EOF then WScript.Echo "No Data Returned" Else Do Until recordset.EOF WScript.Echo recordset.Fields.Item(0) ' & vbTab & recordset.Fields.Item(1) recordset.MoveNext Loop End If The SQL string that I use is fairly standard except I want to pass a parameter to it. It is something like this: SELECT column1 FROM table1 WHERE column1 IS LIKE ? I understand that ADO should replace the "?" with the parameter value I assign in the script. The problem I am seeing is that the Parameter object shows the correct value, but the command object's parameter field is null according to my debugger.

  Read the article

• Display an image as a splash screen when running Windows batch file, vbscript/wscript or Python cons

  - by Malcolm

  Any ideas how I can display an image file (bmp or png) centered on the screen as an application splash screen when running a Windows console script based on a batch file, vbscript/wscript or Python console script? I'm not interested in a wxPython solution - that's too much overhead just to implement a cosmetic feature like a splash screen. Thank you, Malcolm

  Read the article

• How can I click through an alert box with a VBScript automating IE?

  - by DeliriumTremens

  I have a VBScript that is running through a list of actions in IE, and at one point the site displays an Alert box with "OK" and "Cancel" as options. 'OK' is focused when the alert box appears, however SendKeys "{ENTER}" isn't doing the trick. I think perhaps the browser window still has the focus of the VBS. How can I tell the VBS to 'OK' the alert box and continue with the routines?

  Read the article

• How can I copy an image from the clipboard to Microsoft Word through VBScript?

  - by lakshmi

  I am trying to copy an image from the clipboard to Microsoft Word using VBScript. How can I do this?

  Read the article

• Is there a way to advance through a for loop by a value instead of one by one in VBScript?

  - by Rob Segal

  I have a one dimensional array in VBScript that I would like to run through but have the ability to advance by 2,3,4 etc. on each iteration of the loop. In C this would be trivial as... for (int i = 0; i < 10; i+= 2)

  Read the article

• How to change cscript.exe to wscript.exe execution for all VBScript files?

  - by i need help

  After installing the new server, I am facing an issue. I have lot of .vbs files, all need to run in wscript, reason, I use all those command like WScript.Echo "hello" I want to be able to see the output when I double click the VBScript file. But when I right click on the vbs file, I see console, I want to change the default to Windows host, globally! How can I do that?

  Read the article

• Is the Sleep operation no longer used in VBscript?

  - by Cheesus Toast

  The "Sleep" command as stated in many places over the internet (including here on this forum) DOES NOT WORK. Is it now an obsolete command? I am writing the VBScript code like this: sub button1_onclick() Wscript.Sleep 1000 div1.innerHTML = textbox1.value end sub It should wait 1 second and then execute that simple command. This is an utterly simple statement but it does not work. Plain and simple. It comes up with an error every time saying: Object Required: 'Wscript'

  Read the article

• VBScript & Access MDB - 800A0E7A - "Provider cannot be found. It may not be properly installed"

  - by Perma

  Hey gang, I've having a problem with a VBScript connecting to an access MDB Database. My platform is Vista64, but the majority of resources out there are for ASP/IIS7. Quite simply, I can't get it to connect. I'm getting the following error: 800A0E7A - "Provider cannot be found. It may not be properly installed" My code is: Set conn = CreateObject("ADODB.Connection") strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\database.MDB" conn.Open strConnect So far I have ran %WINDIR%\System32\odbcad32.exe to try to configure the Driver in 32bit mode, but it hasn't done the trick. Any suggestions would be greatly appreciated

  Read the article

• How do I read 64-bit Registry values from VBScript running as a an msi post-installation task?

  - by Joergen Bech

  I need to read the location of the Temporary ASP.NET Files folder from VBScript as part of a post-installation task in an installer created using a Visual Studio 2008 deployment project. I thought I would do something like this: Set oShell = CreateObject("Wscript.Shell") strPath = oShell.RegRead("HKLM\SOFTWARE\Microsoft\ASP.NET\2.0.50727.0\Path") and then concatenate strPath with "\Temporary ASP.NET Files" and be done with it. On an x64 system, however, I am getting the value from the WOW6432Node (HKLM\SOFTWARE\Wow6432Node\Microsoft\ASP.NET\2.0.50727.0), which gives me the 32-bit framework path (C:\Windows\Microsoft.NET\Framework\v2.0.50727), but on an x64 system, I actually want the 64-bit path, i.e. C:\Windows\Microsoft.NET\Framework64\v2.0.50727. I understand that this happens because the .vbs file is run using the 32-bit script host due to the parent process (the installer) being 32-bit itself. How can I run the script using the 64-bit script host - or - how can I read the 64-bit values even if the script is run using the 32-bit script host?

  Read the article

< Previous Page | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >