Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Autonumber the workbooks in folder
- i have this macro added in excel, this macro prints the excel files one by one in a specified folder, thsi works finethe problem is that i need to add the increment number in all the workbooks( suppose i have 200 workbooks, i need to add 1, 2 , 3...
- Tags: get2santosh@..., sFile, UBound, String Dim, workbook
- Discussion threads 2007-07-28
- autonumber the workbook header
- i have this macro added in excel, this macro prints the excel files one by one in a specified folder this works finethe problem is that i need to add the increment number in all the workbook header( suppose i have 200 workbooks, i need to add 1, 2 ,...
- Tags: get2santosh@..., sFile, UBound, String Dim
- Discussion threads 2007-07-28
Additional Resources
- Subscript out of range: '[number: 83]'
- I am getting the following error on one of my asp pages..Error Type:Microsoft VBScript runtime (0x800A0009)Subscript out of range: '[number: 83]'/agreement_print22.asp, line 96Note: I have bolded line 96.Thanks in advance for the advice!' *** Insert Record: construct a sql insert statement and execute itDim MM_tableValuesDim MM_dbValuesIf (CStr(Request("MM_insert")) "") Then...
- Tags: Dim MM_tableValues Dim MM_dbValues, jason@..., MM_delim, MM_fields, MM_i, MM_i+1, MM_tableValues, programming, Step 2 MM_formVal
- Q&A 2004-10-01
- Formatting data results in Active Server Pages
- If you're writing Web-based applications for your company's intranet, you could be asked to produce output in multiple columns, a la Excel. Not quite sure how to do that? This reprint from our Web Development Zone TechMail can get you started.Editor’s note: This article originally appeared in TechRepublic’s Web Development...
- Tags: Scripting languages, Les Hamilton, Microsoft ASP, RowsToDisplay, ContactRecords
- Technical articles 2001-08-13
- Define VB6 procedure arguments with the ParamArray keyword
- In times when you don't know how many arguments will be passed to a procedure, you might want to think about using the ParamArray keyword. Learn how to use ParamArray in this VB6 tip. In some situations, you may not know ahead of time exactly how many arguments...
- Tags: Microsoft Visual Basic 6.0, ParamArray, Peter Aitken, Visual Basic Tips Newsletter, Argument, Corporate Communications, Microsoft Development Tools, Programming Languages, Marketing, Development Tools, Software Development, Software/Web Development
- Technical articles 2005-09-01
- Determine if a credit card number is valid using VB6
- Determine if a credit card number is valid using VB6article rootToo much workRegarding the code...Total = Total + (CInt(Mid$(CStrResult, 1, 1)) _ + CInt(Mid$(CStrResult, 2, 1)))On a Mod 10 Double-Add (the common name for this...
- Tags: Boolean Dim Result, credit card, credit card number, KingPlayer, loop, Microsoft Visual Basic 6.0, Mid$, mod check, programming, Result, Visa International
- Discussion threads 2005-08-12
- DNS Group policy
- Hi AllI am running a 2003 servers AD and i need to change the DNS numbers to all the clients (XP Sp1) on a local site, is there any easy way to do this.I have set up a GPO for this but it is not changing the DNS numbers on...
- Tags: arrDNSServerSearchOrder, blnFound, DHCP, DNS, DNS server, nick.askew@..., windows
- Q&A 2005-09-12
- Choose a method for passing arrays to the Oracle Provider for OLEDB
- If you're looking for a way to pass an array of values to a PL/SQL stored procedure, you must use a technique to wrap an array into the proper PL/SQL structure on the server at runtime. Scott Stephens provides you with the necessary code. The Oracle Provider for OLEDB...
- Tags: Oracle Corp., PL/SQL, SQL, Databases, Scott Stephens, Programming languages, Oracle Tips Newsletter, Procedure, Table, CreateObject, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Technical articles 2005-07-26
- how to execute insert query inVB Script
- i have written a the follwing code in vb scriptand it shows the Error "too few parameter expected 1 80040E10how ever this code when written in VB run smoothly' open database dim idim filenamedim RNOdim restnodim fi=1Set con = CreateObject("ADODB.Connection") Set cmd = CreateObject("ADODB.Command") set rs = CreateObject("ADODB.Connection") set rst=CreateObject("ADODB.Connection")...
- Tags: Programming languages, Databases, sitanshuwesley@..., rs.Fields, rtNo, SQL, Chr, CreateObject, Mohan Das Karam Chand Gandhi, rsResult, Access Driver
- Discussion threads 2007-10-18
- Collect domain names to automate admin script customization
- TechRepublicrecently asked members to submit their favorite Network Administration scriptsfor possible publication. One of the first to make a submission was Kevin Wood. For his effort, Kevinearned $100 and the satisfaction of seeing his script published on TechRepublic.Earn $100 for your admin scriptLet us payyou for your original scripts so...
- Tags: Â, Â Â, defaultNamingContext, domain, domain name, Guest Contributor
- Technical articles 2005-10-17
- Visual Basic
- How do you read data from a .txt file into a visual basic project?The data is set out as follows:A - indicates magic numberX - 0 100 X & Y indicate the values for the graph axisY - 0 80M - indicates how many seriesN - indicates that...
- Tags: aryData, Dim aryData, Dim intFile, Dim strLine, DoSomethingWith, intCount, Microsoft Visual Basic, pr1mcess@..., programming, text-file
- Q&A 2005-08-18
- visual basic to access
- Hi, Does any body know a way or tool to convert a Visual Basic 5 project to Microsoft Access 97 or 2000.I was able to transfer/convert some of the code and forms.But I'm having a hard time converting a few PicturBoxes to somethinbg similar in Microsoft Access.ThankxWhile there are...
- Tags: Microsoft development tools, Programming languages, Microsoft Office, Databases, Microsoft Access, Microsoft Visual Basic, Space
- Q&A 2006-03-22
- Runtime menus in VB6 allow for more flexibility
- Menu controls provide a great way to offer users functionality needed to perform various tasks. The ability to control your menus in runtime also comes in handy. For instance, your application might show a list of recently opened files in a way that's similar to how Microsoft applications work. We'll...
- Tags: Irina Medvinskaya, Microsoft Visual Basic 6.0, Menu Editor, runtime, menu item
- Technical articles 2003-03-24
- Rebroadcasting UDP packets to multiple addresses
- Lamont Adams answers a question from a reader who wants to know how to forward selected UDP packets. And as always, we're giving away the source.Q: “How can I capture UDP messages sent from multiple IP addresses and rebroadcast them to another set of multiple IP addresses?”—Juan OsornoA: There are...
- Tags: NETWORKING, Lamont Adams, UDP, Microsoft Winsock, IP address, IP
- Technical articles 2001-05-30
- << Previous
- page 1 of 1
- Next >>
