| Subject | Date Asked | Expert |
|
| 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 ...
|
| how to manipulate the folder | 10/11/2006 | Miguel Zapico |
Q: i would like to know the code in visual basic how to put a folder in a picture box, to rename, ...
A: I am not completely sure that I have understood what you need. In any case, this extract from the ...
|
| Fetching data from WMI | 10/10/2006 | Miguel Zapico |
Q: I have never worked on WMI and I am not much aware of it.I need to fetch hardware and software ...
A: The topic is big, but the short answer is yes, you can do it. There are some good examples at ...
|
| VB script to copy/paste date in Excel | 10/4/2006 | Miguel Zapico |
Q: I am trying to open an excel worksheet, paste data that will be in the clipboard to sheet 2. Then ...
A: I have tweaked the script, the main issue is that you are declaring and setting the objects but you ...
|
| Delete and Add new Excel Sheet using Vb script | 9/6/2006 | Miguel Zapico |
Q: I have Created a Generic Application in Excel using VB Script.In this App I am Browsing the Excel ...
A: The Delete method of the Worksheet object in Excel shows a dialog box by default, you may have some ...
|
| writing a macro script | 9/5/2006 | Miguel Zapico |
Q: I am trying to learn how to write a macro script for the iopus.com software. I was wondering if you ...
A: Sorry, I have never used this software. What I used for Internet browsing was AutoIt ...
|
| VB Script program running before logon | 8/24/2006 | Miguel Zapico |
Q: is it possible to set a vb script to run before windows logs on, or before the desktop loads?
A: One option can be running the script as a service. This way the script will be run when the machine ...
|
| An algorithm for generating unique number sequences | 8/23/2006 | Miguel Zapico |
Q: An algorithm for generating unique number sequences from a given set of numbers. eg. Set {7, 3} the ...
A: There is an example that can be useful in: http://j-walk.com/ss/excel/tips/tip46.htm The algorith ...
|
| Setting up internet expolrer proxy setting | 8/22/2006 | Miguel Zapico |
Q: I want to set my internet explorer setting through VB Script. how can i do this.
A: Usually these changes are done writing in the registry, as the InternetExplorer object have ...
|
| Using Save As with VBA and Input Boxes | 8/10/2006 | Miguel Zapico |
Q: That piaece of code does infact still do logical comparisions and is saving the file as true, what I ...
A: You can encode everything on the fileSaveName, including the extension. Something like: ...
|
| Using Save As with VBA and Input Boxes | 8/9/2006 | Miguel Zapico |
Q: I need to know how to use input boxes to generate a file name that VB can then use to save the file ...
A: I think the trick is on the use of parenthesis to concatenate text, the code is doing logical ...
|
| VBA | 7/24/2006 | Miguel Zapico |
Q: I have declared an object variable for a class and instantiated. When a use a method available in ...
A: Sorry, I don't have that object on my system. What application is it refered to? Also, what is the ...
|
| Access data page customization during run time | 7/13/2006 | Miguel Zapico |
Q: I have a access data page that shows customer data. Now it hasa field 'Shipping status' and ...
A: I haven't worked with Access data pages, but from a Visual Basic perspective this is a good place to ...
|
| Help need in text populated | 6/22/2006 | Miguel Zapico |
Q: I am wondering if you would help me with this? I am using _vbscript or _javascript with ...
A: Sorry, this is outside my experience, but at least I will try with some tips. From my limited ...
|
