Recent content by SirLaugha1ot

Is there a way, using VBA, to search Outlook 2000's Public Folders for everything posted on a particular date (e.g. today) and copy/paste only the subject into Excel?

Thanks ide...but since I'm still kind of learning VBA, could you breakdown the code and explain it to me? I tried to copy/paste it into Excel as a macro and run it and received an error. Thanks again for the help!

I'm having trouble trying to figure out how get a list of filenames from a folder in Outlook2000. In Public Folders, I have a directory containing notepad files and I would like to be able to search for files posted on a specific date and copy only the filenames (subject?) into Excel. I'm not...

Worked like a charm - Thanks everyone!

The cell is formatted for military time. When I switched it to text, it turned into a decimal value and the result using the formula you supplied gave me #VALUE. Here is an example of what I have...I'm trying to get it to calculate how many jobs were completed per hour. Start 15:52...

I am trying to figure out how to take a time (i.e. "8:04" for time spent-not the actual time) and amount completed (i.e. 65) and figure out how many were completed per hour. The time spent comes from the difference between the start and stop times. My problem is that I cannot figure...

I have two fields - DateReceived and DateCompleted which are in mm/dd/yyyy format. I'm trying to figure out how to create 3 queries - one that tells me when DateReceived and DateCompleted were within the same day, one that tells me when DateReceived was 1 day before DateCompleted and a third...

Is there something else I could use in an Access form besides checkboxes that would carry over into Excel?

I have several checkboxes that I use in my form. When I run a report, the checkboxes are visible yet when I try and cross the info over into Excel, they disappear! The only information that crosses over is anything that is a text or number field. How do I get the checkboxes to show in...