You are here:
- Home
- Computing/Technology
- Basic
- VB Script
VB Script/Questions
| Subject | Date Asked | Expert |
| generate unique numbers | 7/8/2011 | Subbu |
| Q: 1. I want vb script to generate unique numbers. Say for example, Input: 1,8 Output should generate ... A: Kavitha, I misunderstood your question earlier, sorry for that, here you go: Call uniqueNum(1020, ... | ||
| Rounding Numbers | 1/7/2011 | Subbu |
| Q: Is there an easy VB script that I could use in my batch programming that would take an input of a ... A: use round function. Syntax: round(value,decimalplaces) For example: a=84.32 msgbox round(a,0) 'This ... | ||
| function ...objmail.send not working | 9/21/2009 | Subbu |
| Q: I am having problem with objmail.send function... can u plz tell me in which circumtances this ... A: Vikash, what is the error message you are getting after execution of objmail.send. objmail is ... | ||
| Run a scipt to save an outlook attachment to a specific file path | 9/17/2009 | Subbu |
| Q: I am a complete beginner to VBSCripting and have been asked to write a script that, once run, will ... A: John, Sorry for late reply, I am very good in Lotus Notes email, even though I will try. have you ... | ||
| VB or excel macro: find 2-subsets of an n-set | 9/15/2009 | Subbu |
| Q: I hope you’ll consider taking this on. I would like to know if there is an excel function or how I ... A: Tim, Sorry for late reply (I had couple of break fixes in my current SAP application), here you go: ... | ||
| how to get which key has been pressed. | 9/10/2009 | Subbu |
| Q: I wants to know about how can i get which key has been pressed from VB script (except input box ... A: Now I understand your question. When you run the vbscript to copy files from one location to ... | ||
| please help | 9/7/2009 | Subbu |
| Q: I am preparing a student registration program for my college as a student. I am using labels, ... A: Where are you storing all student details? I mean what backend you are using. Make sure all ... | ||
| VB Script - Need Code | 9/5/2009 | Subbu |
| Q: In my Page there are Two Text Boxes. If I type the following values like "C096" in the First text ... A: Mahesh, you can declare them as a const in General section Example: private const C096 = "Non ... | ||
| DAO 3.60 for vbscript in VSReports | 9/5/2009 | Subbu |
| Q: Now I have DAO360.dll at the same exact location you gave me. What do I do with it? Where should I ... A: Select Tools Menu / References and try to find "Microsoft DAO 3.6 Object Library" in the list. If ... | ||
| VBScript ADO VSReport question | 9/4/2009 | Subbu |
| Q: I already have a RecordSource in my Inventory Report. I have two groups in this report Machine Type ... A: If you have Office 2000, you already have DAO 3.6. The name of the library is "Microsoft DAO 3.6 ... | ||
| VBScript ADO VSReport question | 9/3/2009 | Subbu |
| Q: I already have a RecordSource in my Inventory Report. I have two groups in this report Machine Type ... A: Claude, when you type "Dim db as" then you will get list of objects in a drop down list. Are you ... | ||
| VBScript ADO VSReport question | 9/3/2009 | Subbu |
| Q: I already have a RecordSource in my Inventory Report. I have two groups in this report Machine Type ... A: If you know the SQL query then this is the way you can implement: dim db as database dim rst as ... | ||
| Obtain total messages in queue for Excahnge 2003 | 7/22/2009 | Subbu |
| Q: How could I use VB scripting get the total messages in the outgoing queues for Exchange 2003 and ... A: Recently I did sending meeting Invitation using VB code, for this I used LOTUSNOTES object, I ... | ||
| VB code to find average in Excel worksheet | 7/19/2009 | Subbu |
| Q: I have three columns, col a, col b, col c. i want to write a VB code to find the average of few ... A: Sanjay, You don't need VB Code for this, use this formula in C4 cell: ... | ||
| VBScript for Oulook 2007 Macro | 7/13/2009 | Subbu |
| Q: Hllo Subbu, I need help in writing a VB Script to create a Macro in Outlook 2007. I need to create 4 ... A: Sergey, I donot have an idea how Outlook encoding will work. Can you try to develop something ... | ||
| oracle-vb | 6/29/2009 | Subbu |
| Q: Pl. tell me how to display an image file stored in a oracle table in vb-report form A: Uma, I have't tried this but I have an idea, just try this. 1. Create data source(Dynamic or DSN) ... | ||
| vbs script to be modified | 6/11/2009 | Subbu |
| Q: I have this script: This code prints the last logon timestamp for a user. ' ------ SCRIPT ... A: Raducu, Regarding point 2: Set objFSO1 = CreateObject("Scripting.FileSystemObject") Set objFile1 = ... | ||
| VBScript to move a file using a wildcard | 6/11/2009 | Subbu |
| Q: I am trying to write a VBScript to move a file from a specific folder to a specific destination but ... A: Steve, I am really sorry, I forgot Copy command. Please try this and let me know. dim objshell ... | ||
| vbs script to be modified | 6/10/2009 | Subbu |
| Q: I have this script: This code prints the last logon timestamp for a user. ' ------ SCRIPT ... A: Raducu, create a text file and save as "userlist.txt" at "c:\" and past your all userdn. Make sure ... | ||
| Save As macro | 6/1/2009 | Subbu |
| Q: I have a save as macro defined to operate when someone selects a specific text box in the Excel ... A: Micah, If user select No or Cancel VB Err 1004 will raised. You have to decide what will happen ... | ||
| problem in set datagrid | 5/26/2009 | Subbu |
| Q: hye..i have a problem in how to set a different data from many recordset in datagrid ??i use adodb ... A: Are you using ADODB ActiveX object or COM. I would prefer COM for these kind of jobs. Take a ... | ||
| VB script for excel | 5/21/2009 | Subbu |
| Q: How to change the name of the existing worksheet in excel Eg: sheet1 to data1 how to insert a new ... A: I was thought the same that question is incorrect and you were trying to insert cells using VBA / ... | ||
| VB script for excel | 5/20/2009 | Subbu |
| Q: How to change the name of the existing worksheet in excel Eg: sheet1 to data1 how to insert a new ... A: Sreedhar How to change the name of the existing worksheet in excel: Double click on sheet1 and ... | ||
| Extract DAte from a string | 5/18/2009 | Subbu |
| Q: l3=12/3/2009 l3=23/4/2009 ... ... I need to extract the date part from it... I do not want to trim ... A: Did you try with changing date format in custom? Steps: 1. select the Datevalue cells 2. Goto ... | ||
| Extract DAte from a string | 5/15/2009 | Subbu |
| Q: l3=12/3/2009 l3=23/4/2009 ... ... I need to extract the date part from it... I do not want to trim ... A: Ashish, There are two steps to get your dates. Col A Col B 13=11/12/2008 39764 use ... | ||
| Set Cursor Position | 5/6/2009 | Subbu |
| Q: I am operating ISeries Access for Windows and I need some vbscript to set the cursor to specific ... A: The inner window in your Image not clearly visible. Set focus on inner window and Hold Alt key then ... | ||
| Subnets script | 5/5/2009 | Subbu |
| Q: I contacted you yesterday with a problem with subnets and sorry it was my mistake the script was not ... A: strNextLine will be having your text file single line value (whatever it is, in this case you have ... | ||
| Set Cursor Position | 5/5/2009 | Subbu |
| Q: I am operating ISeries Access for Windows and I need some vbscript to set the cursor to specific ... A: Jesse, Sorry for late reply, here is your code: Copy this single line code and Paste to your ... | ||
| Subnets script | 5/5/2009 | Subbu |
| Q: I contacted you yesterday with a problem with subnets and sorry it was my mistake the script was not ... A: You dont need to split the line with ",". Actually there is no "," in that line. You just need ... | ||
| Subnets script | 5/5/2009 | Subbu |
| Q: I contacted you yesterday with a problem with subnets and sorry it was my mistake the script was not ... A: I need some information from you. What your brso01_colombia_1stwave.txt file contains. I mean each ... | ||
| vb script modify question | 5/4/2009 | Subbu |
| Q: I have this script which modifies the site assignment for a subnet in Active Directory: ' This code ... A: Here is the code for just reading a text file: ' Get a free file number nFileNum = FreeFile ' Open ... | ||
| VB | 4/22/2009 | Subbu |
| Q: I have time series data collected every second for 1 day. I need 10 second averages. The time ... A: I am assuming your data is like this: Time Data Average 11:43:01 15 11:43:02 12 ... | ||
| VB | 4/21/2009 | Subbu |
| Q: I have time series data collected every second for 1 day. I need 10 second averages. The time ... A: As you said you have 86400 data points. One quick question, are these data points stored in two ... | ||
| internet shortcut in program subfolder. | 4/18/2009 | Subbu |
| Q: I am able to create an internet shortcut to the desktop via available vbscript but haven't been able ... A: Yes, You can handle any kind of error. First find out what is the error number you are getting(Here ... | ||
| internet shortcut in program subfolder. | 4/17/2009 | Subbu |
| Q: I am able to create an internet shortcut to the desktop via available vbscript but haven't been able ... A: can you email me value of strDesktop variable has. If it is this C:\windows\desktop then use this ... | ||
| Excel VB script | 8/27/2008 | David Barrett |
| Q: I would like to move to each row with the word "Total" in it and delete the row and repeat until ... A: Example of this: Sub DeleteTotal() Dim rngTotal As Range Set rngTotal = ... | ||
| How to loop for each worksheet? | 7/24/2008 | David Barrett |
| Q: Step1: I have a script that searches for a particular data from worksheet one, and pastes all the ... A: I am not sure entirely what you mean, but if you mean you want to use the above sub to work on ... | ||
| Saveas | 7/23/2008 | David Barrett |
| Q: Help. I want to get my macro to check if a filename already exists, and if it does create next ... A: Sorry, my mistake. Below pads with zeros. Sub onemore() Dim objFSO As Object Dim i As Integer ... | ||
| Saveas | 7/22/2008 | David Barrett |
| Q: Help. I want to get my macro to check if a filename already exists, and if it does create next ... A: Well, there was a small oversight on my part (forgot the .xls extension). Additionally, the code as ... | ||
| Saveas | 7/22/2008 | David Barrett |
| Q: Help. I want to get my macro to check if a filename already exists, and if it does create next ... A: The code below demonstrates how you can achieve this. Amend the commented lines as appropriate. ... | ||
Subbu
Top Expert on this page
Expertise
I can answer VB Script questions which are related to Visual Basic / VBA / QTP Scripts.
Experience
8 Years
Education/Credentials
Master of Computer Applications
Awards and Honors
Established Member from QA Forums and
Brainbench certification
©2012 About.com, a part of The New York Times Company. All rights reserved.