| Subject | Date Asked | Expert |
|
| 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. ...
|
| internet explorer script errer | 11/14/2006 | Miguel Zapico |
Q: What causes the screen to to come up internet explorer script error when I am trying to print a ...
A: It looks like the web page has not being designed properly. There may be many causes, but usually ...
|
| String Manipulation - Extract | 11/9/2006 | Miguel Zapico |
Q: Hey Miguel, Wondering if you could help me out here. I have headers going from B1:T1 with ...
A: Your code works, it extracts to the variable strStock the correct ticker. In any case, if you want ...
|
