You are here:
- Home
- Computing/Technology
- Basic
- VB Script
VB Script/Questions
| Subject | Date Asked | Expert |
| 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 ... | ||
| select the last 3 rows in excel | 6/19/2006 | Miguel Zapico |
| Q: I need to know how to select the last three rows in an excel workbook so they can be deleted in a ... A: You may use the currentrange property, with a code like this: sub Delete3Rows() Dim myRange As ... | ||
| MS projects open file | 6/16/2006 | Miguel Zapico |
| Q: my question is, how can i open a file in msproject without getting promted with "file" should be ... A: Sorry, I have tried your code and it works perfectly in my computer. You have the true in the right ... | ||
| DATA GRID | 6/16/2006 | Miguel Zapico |
| Q: I was wondering if someone could help me. I am developing a form in vb 6.0 which has a MS Access db ... A: I don't have vb installed, so I'll try to answer the best I can. This is a code that queries a ... | ||
| ADODB connection | 6/8/2006 | Miguel Zapico |
| Q: . i would to know some script in creating a public function of ADODB connection thru access and ... A: You can check this page for Oracle, it has some good examples: http://www.orafaq.com/faqmsvb.htm I ... | ||
| vb excel | 6/6/2006 | Miguel Zapico |
| Q: I'm new to the functions in excel and would appreciate if you could provide me with a sample ... A: As a first approach, you can browse the templates section of the Microsoft website: ... | ||
| vb excel | 6/5/2006 | Miguel Zapico |
| Q: I just have a quick question regarding microsoft excel and visual basic access. I'm learning excel ... A: From your description, it looks like a tabular entry form can be the easiest choice. You can ask ... | ||
| Getting a form to work on an AOL website | 5/19/2006 | Miguel Zapico |
| Q: Miguel, I run a community web site out of my AOL account and would to run forms to allow the users ... A: Sorry, I haven't used VBScript on web sites. What is significant here is that AOL won't let you use ... | ||
| FileSystemObject | 8/16/2005 | Dennis Cassøe |
| Q: I am using Windows XP Pro, with IIS as a dev web server for asp. I want to use the FileSystemObject ... A: FileSystemObject or FSO is supported by IIS, but it will only read files locally placed on the ... | ||
| Read Text File | 8/11/2005 | Dennis Cassøe |
| Q: I'm trying to open a text file and read from a server on the Internet. I'm using vbscript and ... A: You can't just connect to a file on a server through the internet. To do this you'll will need to ... | ||
| Create Excel in asp | 7/2/2005 | Dennis Cassøe |
| Q: Sir i m using the following code: <% Set xml = Server.CreateObject("MSXML2.ServerXMLHTTP") ... A: Im not sure, but it could be, that when you create the excel file by importing test.htm, test.htm is ... | ||
| Change computer name and add to the domain | 5/23/2005 | Igor |
| Q: I've been working on a script that will help me change a computer's name and then add that computer ... A: Joins the local computer to a domain and creates the computer's account in Active Directory. Const ... | ||
| VB Logon Script | 3/13/2005 | Igor |
| Q: In a VB Script is it possible to call another VB Script? I have tried the Call xxx.vbs but I get an ... A: Runs a program in a new process. object.Run(strCommand, [intWindowStyle], [bWaitOnReturn]) ... | ||
| Vbscript - Sql - Access | 3/10/2005 | Igor |
| Q: Igor, I appreciate your help. I'm still having problems. Here is my code again. Set ... A: You have superfluous ")" ... cnn.Execute "INSERT INTO Circulation ( [Circulation Day], [Circulation ... | ||
| set margins for a page | 3/7/2005 | Igor |
| Q: I have created an inventory report in Access 2003 When I print this form somehow the margins for the ... A: for example Public Sub SetMarginsToDefault(ByVal strName As String) Dim PrtMipString As ... | ||
| Vbscript - Sql - Access | 3/3/2005 | Igor |
| Q: I'm trying to make a script that will add a record to a Microsoft Access 2003 database that is ... A: for example ... Set cnn=CreateObject("ADODB.Connection") cnn.Open ... | ||
| using the wshshell object in vbscript | 9/30/2004 | Igor |
| Q: We have an ASP page where we want to run a vb script to execute an external command and then return ... A: Im not specialist with ASP (WSH only) but you can try like this JScript: <% var objMyObject = ... | ||
| load form and msgbox | 3/1/2004 | Dennis Cassøe |
| Q: Followup To Question - Dear Dennis, i really need help terribly. I am having some problems, and i ... A: Well, as I said, I haven't used asp.net :) this makes it rather hard to tell excatly what you have ... | ||
| load form and msgbox | 3/1/2004 | Dennis Cassøe |
| Q: i really need help terribly. I am having some problems, and i already stuck in this stage for very ... A: part 2 Well im not a asp.net programmer :) only vba,vb, and asp, and set normally works for me, ... | ||
| Windows Settings via VBS | 2/28/2004 | Dennis Cassøe |
| Q: I have a request from a coworker to develop a script that will: 1. Set/change the Windows Desktop ... A: Well a large problem, and I don't do other peoples programming :) But a couple of links that might ... | ||
| internet explorer script error | 2/21/2004 | Dennis Cassøe |
| Q: an error has occurred in the script on this page. line: 16 char: 1 error: syntax error code: 0 do ... A: Well this normally happens when they have made errors in the javascripts that they can use on the ... | ||
| Mouse events inside web page | 2/16/2004 | Dennis Cassøe |
| Q: I want to detect where does the user clicks (all mouse events) inside a web page,and what text or ... A: Well the internet isn't a normal program and therefore it is not possible to track all user clicks. ... | ||
| schedule of dates for ms access form | 2/13/2004 | Dennis Cassøe |
| Q: I am working on a database in ms. access and would like to know what code would work to get a date ... A: Im not sure I understand the problem. You want a date, and then you want 14 days added to it, and ... | ||
| VB6 front end to EXCEL sheet | 2/9/2004 | Dennis Cassøe |
| Q: Dennis Not sure if you are able to help me and this makes sense. For some time I have been ... A: Well, there isn't at sheet that just fits into vb as access have the data grids in vb. So you'll ... | ||
| Regedot | 7/19/2003 | Francois-Yanick Bourassa |
| Q: I have been using a trial program for 30 days and dont wanna buy it. Because of this I installed ... A: It is depend on what is the software and how the manufacturer built it and also your knowledge in ... | ||
| Newbie to ASP coding(Part #2...Revised???)..... | 5/19/2003 | Robert D. Fahey |
| Q: Mr. Fahey, I just sent you an email regarding my ASP problem. I do have an ASP book to refer to, ... A: Dennis, Ok, you fixed the first problem that I saw with your old code, the Set objTable = ... | ||
| I set date format mm/dd/yyyy in my computer regional options, but I get date format yyyy-mm-dd in vbscript, can you help me ? | 4/6/2003 | Francois-Yanick Bourassa |
| Q: I set date format mm/dd/yyyy in my computer regional options, but I get date format yyyy-mm-dd in ... A: The format date from your computer and the one from the VBScript are not completely related. You can ... | ||
| Internet based database | 2/24/2003 | Francois-Yanick Bourassa |
| Q: Francoise, I am looking to develop an internet based database application. I am new to this kind ... A: First of all, to devleop an internet based database application, you need a programming language ... | ||
| ASP & VBScript | 2/5/2003 | Francois-Yanick Bourassa |
| Q: I am a web designer by trade. Recently I have been asked to develop a web application and although ... A: The VBScript can be place, usually, between the tags <head></head>, after the tag <title></title>. ... | ||
| combo box and ASP | 1/7/2002 | Shantanu Khasnavis |
| Q: The extract of following form is passed on in a file ASP. which is the solution to get back the ... A: I have tried the script and find no possibility why it is giving a problem. It is working fine here. ... | ||
Miguel Zapico
Top Expert on this page
Expertise
I can answer question about how to use scripts to consolidate data, connect different systems and automate tasks. I have no experience on using VBScript on web programming.
Experience
I have been using VBScript and Windows Scripting Host as my swiss tool for the last 6 years.
Organizations
New York PC users group (NYPC)
Independant Computer Consultants Association (ICCA)
Education/Credentials
Microsoft MCSE in Windows NT
©2012 About.com, a part of The New York Times Company. All rights reserved.