Results 1 to 6 of 6
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Errors with embedded Excel file in Outlook appt (2

    I don't see an attachment.

    I don't know if it is acceptable to you, but you could remove all the check boxes, and instead use Validation of type List, with a list consisting of TRUE and FALSE as source. Selecting from a drop down list is slightly less convenient than clicking a check box, but you wouldn't be using anything 'foreign' to Excel any more, so it should work even in an embedded worksheet.

  2. #2
    Star Lounger
    Join Date
    Sep 2001
    Location
    Perth, Western Australia
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Errors with embedded Excel file in Outlook app

    Hans

    Wow - don't you ever sleep?

    I thought that this might be a workable solution, as the dropdown list seems to work OK. I have tried to attach the file again, but it is exactly where we left off a couple of days ago (I lost it after previewing the message before posting!)

    Thanks again!

    Neil

  3. #3
    Star Lounger
    Join Date
    Sep 2001
    Location
    Perth, Western Australia
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Errors with embedded Excel file in Outlook appt (2

    Hi all

    I am using a time & priority management methodology that requires me to keep a task list within an Outlook appointment. I was doing it in plain text, then I thought "why not embed an Excel file?" to make it easier to sort tasks by priority, date, completion etc.

    With some help from the amazing Hans V, I have got the Excel file working just I want it to (attached) - but when I embed it into an Outlook appointment, one function (clicking on a checkbox to indicate that a task has been completed) generates the following errors:

    1. 'doing - Appointment .xls' could not be found. Check the spelling of the file name, and verify that the file location is correct.
    If you are trying to open the file from your list of most recently used files on the File menu, make sure that the file has not been renamed, moved, or deleted.

    2. 'doing - Appointment .htm' could not be found. Check the spelling of the file name, and verify that the file location is correct.
    If you are trying to open the file from your list of most recently used files on the File menu, make sure that the file has not been renamed, moved, or deleted.

    (The title of the appointment is "Writing/doing" - which explains the beginning of each error message.)

    The other functions in the Excel file (auto-sorting mostly) work perfectly in the Outlook appointment - it's just clicking the checkbox that doesn't work.

    My preference is to embed the Excel object *without* a link to the file, so that I can edit it within the Outlook appointment.

    As always, I'd be most If any of the Loungers can suggest any techniques for doing this so that I can get it to work completely without errors. I have posted this in the Outlook forum as well, as I'm not sure whether the problem lies within Excel or Outloook - apologies in advance to those who see this twice.

    Best regards

    Neil

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Errors with embedded Excel file in Outlook app

    How did you embed the worksheet? If I create an appointment and select Insert | Object..., select From file, then browse to the Excel workbook and OK my way out, I can click the check boxes without problem (after double clicking the Excel object and enabling macros)

  5. #5
    Star Lounger
    Join Date
    Sep 2001
    Location
    Perth, Western Australia
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Errors with embedded Excel file in Outlook app

    Hans

    That's exactly how I embedded it. The first time I dbl click in an Outlook session, it asks me:

    Some objects contain viruses that can be harmful to your computer. It is important to be certain that this object is from a trustworthy source.
    Do you trust this embedded object?

    I click "yes" and the problem is there.

    I'm wondering whether its a macro security thing in Excel or Outlook. Both are set to high.

    I'm going out for the rest of the day but will look forward to checking in for more great ideas this evening.

    Cheers

    Neil

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Errors with embedded Excel file in Outlook app

    I also get the warning. Macro security is set to Medium in all my Office applications. I'm using Office XP SP-3.

Posting Permissions

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