Errors with embedded Excel file in Outlook appt (2

Topic

New Reply

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.

Reply | Quote

Replies

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

Reply | Quote

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)

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote