Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SirLaugha1ot

    Copy message subject to Excel

    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?
  2. SirLaugha1ot

    Copy Filenames into Excel

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

    Excel-Average completed per hour

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

    Query of dates

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

    Checkboxes

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

Part and Inventory Search

Back
Top