Search results for query: *

This may be somewhat of a newbie question, but I'm having a hard time wrapping my head around it. I have a table that contains several columns including: Name, Type, Qty, Response_Time, and Complete_Time. Name is the name of the person, Type is a type of work "unit", Qty is the number of work...

I have a small userform that prompts the user to select an existing workbook to be used as output for a macro. I also need the user to specify which sheet in the output file will be used. Is there a way to display a list of the worksheets in a workbook without actually opening the workbook? My...

I've been tasked with fixing someone else's VB.Net application, and this is the first time I've ever used regex. I understand some of the basics, but I'm having trouble doing what I need to do. I have to parse through an email header and extract email addresses, as well as the "From", "To", and...

I'm trying to reference a group of columns based on an incrementing integer variable, and I'm having some trouble selecting them. I have a column counter variable called intColCounter, and I'm using the Columns property the way VBAJedi mentions here: thread707-730362. Columns(intColCounter + 2...

I've got a userform set up to display a message if a particular file does not exist. The pathname and filename are stored in two different cells on my worksheet. When both the correct pathname and correct filename are present, FileExists returns True (as expected), however, even when I delete...

I wrote a macro to filter a list of records and copy/paste the matching records to a new worksheet. Each matching record had at least one more that shared the same file ID (i.e. multiple records per file ID), and in order to separate them and make the list easier to read, I copied the file ID...

I have a situation where I need to use multiple ranges in the PublishObjects.Add method. My range object comes out to be "A3:A15, T3:AB15". This seems to work fine by itself, but once I try to use it in the PublishObjects.Add method, it errors out with an application- or object-defined error. A...

Hey all. I'm having a weird issue that I just can't seem to resolve. I have a macro that runs through the cells in column A of my worksheet and looks to see which cells are empty and which contain *something*. It actually used to work fine, then the format of my spreadsheet changed, and suddenly...

I'm writing a small app that will condense plain text copied from the clipboard. To do that, I need to remove extra spaces and linebreaks. It's ok if there's one space between characters, but I would need to change " " to " ", for example. My first thought is that I would need to parse the...

I haven't been able to locate a thread that covers this, nor a suitable function in the help files, so here goes: I need to convert a length of time into a decimal format. For instance, 1:34:45 (one hour, 34 minutes, 45 seconds) needs to be 94.75 minutes. I've been looking at the TimeSerial...

I have 2 tables: CommTracker, and Brokers. The Brokers table contains about 16 records, each listing a different broker that works for us. I'm using an autonumber field as the PK, and I also have a field for the Total Commission (per broker). In the CommTracker table, I have around 100...

I recently learned how to use SaveSetting and GetSetting, and while it has been very useful, I'm having a small problem. My code works fine on my system, but when I try it on another system, it doesn't save anything to the registry. Both systems are running Office 2000, and macros are enabled...

Hi all. I'm getting this error message on a VBA form that has worked great in the past. I made a change this morning, however. I removed a textbox and replaced it with a combobox. I did a Find/Replace on all references of the textbox in my code and replaced them with references to the...

I'm compiling a CD of apps that our company uses, and I wanted to put in a little HTML file that contains links to the install files of each app. However, when clicked, I get the same old option of "Save to disk" or "Run from this location". Is there a way to actually run a...

I would like to be able to filter my main form upon opening. The table for this form contains a Yes/No field called "Deleted". I have set the Filter property of my form to: Tables![Case Data]!Deleted = No but it still displays all records (even though I have marked 6 as deleted)...

I've been toying with this for some time now, and I haven't been able to come up with a working model. I have 3 columns of data in an Excel worksheet (C, D, & G). Column C only has one changeable cell (C7) and the rest are changed by formulas. Column D can be changed from rows 8 to 29, and G...

I'm getting a "subscript out of range" error on the following code and I can't for the life of me figure out why. ' General declarations Option Base 1 Public varPay as Variant Public Sub Userform_Initialize() varPay = Array(4) End Sub Public Sub cmdAdd_Click() Dim...

I'm sure someone has asked this before, but with the Keyword Search down at the moment, I haven't been able to find a similar question. I need to look up a value in an array, based on the values looked up in columns and rows. For example, I have a row of values (B13:F13) and a column of values...

My userform has about 30 controls on it. Their tabindex properties are not in the correct order, so I need to renumber them. I was able to successfully do this on the first 6 controls, but after that I am unable to do it. I thought it might have something to do with duplicate tabindexes, but...

Is there a function that will convert "$1234.56" to "one thousand two hundred thirty four dollars and fifty six cents"?