Recent content by NWBeaver

This appears to be part of an ASP application, if you haven't already done so you might want to post this in the ASP or ASP.net forum. From what I know about ASP, server scripts are surrounded by the delimiters <% and %>. Perhaps what you have posted is not your complete script, but the...

To add to what John posted, here's the algebra lesson involved in your problem... A linear problem like this can be solved with an equation of the form... y = mx + b where m is the slope and b is the y intercept. If you were to make a graph with the percentage on the x axis and the payment...

It sounds like you are developing an Active Server Page. While VBScript is used for ASP, you might want to post your question in the Tek-Tips ASP.NET forum too. I've also seen other websites that offer ASP tutorials and sample scripts for dealing with databases such as you describe. Perhaps...

What type of data are you writing to the table and wanting to sort? Is it records from a database, or something like a list of files in a directory?

LogParser can also be run from a script, rather than having to open a command prompt and type in a long command string such as the one above. Make a new post in the VBScript Forum if you want to know more about that option, and I can give you an example script.

You might want to take a look at using something like Log Parser, it is a program that you can download free from Microsoft. One of it's uses is to extract file information such as you are asking about. When you install and run it, it will bring up a command prompt, type a string such as this...

The date a file or folder was created or modified is easy enough to get using a VBScript. If that is an option for you then please post this in the VBScript forum, and we can help you with it there. Are you just wanting to know when something was created, or are you trying to detect that...

Here is an example that you can use as a starting point. This code will find and close an open Excel workbook. Note that as is, although this code can handle multiple instances of Excel, the workbook you are looking for must be the active workbook in the particular instance of Excel in which it...

I made one up just for fun using Excel. Here is what I came up with. It just calculates the numbers in the series up to the limit you enter. Sub Fibonacci() Dim Fn() As Single 'Type Long required for a limit greater than 183 limit = 20 'Enter the series calculation limit here. ReDim Fn(0 To...

As you were... that should read like this. Sub Find_DJJ() 'Set the range of cells to look in. Dim objRange As Range Set objRange = Sheet1.Range("A1", Range("A65536").End(xlUp)) 'Search for occurances of a string. strFind = "DJJ:" Count = 0 For Each objCell In objRange If objCell.Value =...

If you insist on doing it with VBA code, it might look something like this: Sub Find_DJJ() 'Set the range of cells to look in. Dim objRange As Range Set objRange = Sheet1.Range("A1", Range("A65536").End(xlUp)) 'Search for decimal points in numeric values. strFind = "DJJ:" Count = 0 For Each...

Here is a piece of code that I have used to do something similar. strName = "AreaID" 'Field name to look for. col = 1 Row = 2 'Start with row 2, Field names are in row 1. While Not rs.EOF While col <= rs.Fields.Count If rs(col - 1).Name = strName Then...

Has anyone actually tried using the zip file script that Mark has linked to above? It appears that it will create the zip file and copy files into it, but I am wondering if doing so will actually compresses the files at all?

Have you considered using a database table? You could write the data from Excel to a table without opening it.

I believe Skip is referring to the example code, which I have pasted in a routine below: Sub statusbar_message() oldStatusBar = Application.DisplayStatusBar Application.DisplayStatusBar = True Application.StatusBar = "Please be patient..." Workbooks.Open Filename:="LARGE.XLS"...