Search results for query: *

Awesome! mrdenny's code works like a charm. Thank you very much! And thanks monksnake and r937 for your input too!

Thanks mrdenny! I will give this a shot and let you know how it works out. Jas

No, I will always need A and B specifically (for quantities), and I will always need A, B, and C for times. I just mentioned the possibility of more work types in case that would affect the query. There will more than likely be as many as 6 or 7 types, but I'm only concerned with A, B, and C.

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...

Thanks Skip. I thought it might be faster to not open the workbook, but this will work. I disabled screen updating, so it all looks pretty seamless to the user. Thanks!

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...

Ok, so I figured out what was happening. I was opening the file for textstream reading and it wasn't closing it. Once I closed the textstream, I was able to Kill the file successfully. It's too bad I never got an error to give me some indication as to what was happening. Oh well. :)

Hi guys. I'm actually having a similar problem that's driving me nuts. When the Kill statement executes, nothing happens. I'm creating an HTML file in the root of C: for the purposes of copying its contents to an Outlook email. When I'm done, I wanted to delete the file just to clean it up, but...

Drederick, Thanks for the code sample. I wasn't able to get it to work like you have it here. The regex wouldn't return any matches. I was able to come up with another regex that gave me what I needed. I took the results, starting with "From:" and put them into an array. From there it was a...

bmgmzp, thanks for the info. I downloaded RegexBuddy and am toying with it now. I had Expresso, but RegexBuddy seems to have a few more options. Drederick, here's a sample header that I'm using: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding...

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've also just realized that I never needed to select the entire columns to begin with. Selecting just a row of cells in the range of columns does the same thing when I insert. I learn something new every day... :)

Skip, Thanks, that appears to have done the trick. I've seen your posts warning people to use Select as little as possible, though I'm not sure why. (Why?) I usually don't use it much, if at all, but I didn't know of any other way of inserting multiple columns at once without using a loop...

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...

Well, formSub was modal, but I couldn't get it to call the particular sub when I closed formSub, but that was because the code was in the Open event of formMain. I moved all the code to a module and just directed all my calls to there. That took care of it. Thanks for the help PH! Jas

PH, That would work, except that I need something for a userform. I'm not sure where I could put the Application.OnTime method and have it constantly running while the userform is being used. I may not have been very clear earlier about what I needed. While the userform is loaded and visible, I...

firefytr, Using Dir() seems to have worked. I'm still not sure what was causing the problem with FileExists, but since this is working, I'm not going to worry about it. Now I just have to figure out how to get an event to run periodically on the form. Like a refresh event or something. Thanks!

The FileExists method. From the VBA help file:

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...

Thanks Zack. I had tried to manually create a border using the "none" line style (in the hopes that I could reproduce the effect), but it didn't work, so I had pretty much ruled it out. I changed my code so that instead of copying the entire row (including the formatting in the first cell), I...