| Subject | Date Asked |
|
| function ...objmail.send not working | 9/21/2009 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 ...
|