Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Outlook t Excel (MS Office 2002)

    I am using MS Office 2002. I want to be able to create a Form in MS Outlook that will update an Excel spreadsheet. I have most of the form and code done. I just need the section that will copy the data to a spreadsheet.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Outlook t Excel (MS Office 2002)

    I don't work with Outlook, but I should be able to help with XL VBA code.

    What are you trying to do in excel?

    I imagine using createobject to open an excel app from outlook, and then use excel VBA to read from the variables and work with excel.

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outlook t Excel (MS Office 2002)

    What I am trying to do is create a form in either Outlook or Excel. I want to add two buttons that wil capture the current time. The first will be called "Start Time" and the second "End Time". The format will be mm/dd/yy hh:mm:ss. As a Clerk is given a new task they push the Start time and when the task is finished the End Time. A third button might be added to close this entry and get ready for the next task. This will clear out the entry fields and be ready for a new record. This is something like a Time card to capture how long it take to do a task.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Outlook t Excel (MS Office 2002)

    For a tutorial on creating a userform check out this site

    On the click event for the buttons you add, you can use now to get the current date/time
    Steve

  5. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Outlook t Excel (MS Office 2002)

    See also <!post=this thread,342619>this thread<!/post> which is mostly about instantiating Outlook from Excel, but the principles are the same if you instantiate Excel from Outlook.
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •