The problem presented itself as thus: “Microsoft Visual Basic … Run-time error ‘-2147024894 (800700002)’: Automation Error . The system cannot find the file specified.”
Read the rest of this entry »
Archive for the ‘Office’ Category
Process (Monitor) of Elimination
Posted by William Diaz on December 2, 2010
Posted in Office, Troubleshooting | Tagged: Process Monitor, Word | 2 Comments »
The Case of the Sluggish Email Message (Outlook HTML Gone Crazy)
Posted by William Diaz on August 5, 2010
Upon trying to move an email into our document management system in Outlook, the user reported the following error: “The item could not be deleted, it was either moved or already deleted, or access was denied.” This was odd, because normally this error is seen when items are deleted from shared mailboxes, as this this Microsoft KB article explains. The folder she was trying to move it into was her own document store, which she had full access. Upon trying to move other items, the error was not encountered.
I asked the user to send me the message and at first glance there was nothing special about the email. It was composed of a few short paragraphs with no special formatting beside some text bolding. The user composed these messages on a weekly basis, sent them to herself and then would re-file them into the DMS.
I asked the user to open the message on her system, noticed it was very slow to open, and eventually caused Outlook to become unresponsive. After restarting Outlook and looking at the message in the message pane of the user I noticed it was 1MB in size. This was odd because there was no attachment.
Read the rest of this entry »
Posted in Office, Troubleshooting | Tagged: Hang, Outlook, Performance | 1 Comment »
The Case of the Macro Security Warning
Posted by William Diaz on August 5, 2010
One of our users was being annoyed by the following macro security prompt when opening a PowerPoint presentation: “Security Warning … contains macros.”
It’s not uncommon to see this warning when opening any Office file that contains macros. However, in the case here, the presentation was a simple slide show that, as far as the author knew, contained no macros. I was asked to investigate. I quickly scanned through the slide show and could see no custom actions or anything else that would indicate a macro. In fact, no macros were listed in the macro window: Read the rest of this entry »
Posted in Office | Leave a Comment »
User Request – Count Outlook Attachments in Outlook
Posted by William Diaz on August 3, 2010
Here is an odd user request presented to one of our techs. The user wanted to be able to count the number of attachments in an email, especially those with many attachments. You can do all kinds of stuff using Visual Basic in MS Office and a quick Internet search revealed some simple VB code that would create macro in Outlook to count attachments
To do this, open the Visual Basic Editor from Tools > Macro > Visual Basic Editor. Right-click the Modules folder and insert a new module and copy and paste the following text into the editor window:
| Sub CountAttachmentsMulti()
Set mySelect = Outlook.ActiveExplorer.Selection End Sub |
Add the macro to the Outlook standard toolbar or create a new one. Do the same for open messages. Now you can select a message, a range of messages, or open a message and run the macro and get a neat dialog box:
Posted in Office | Tagged: Outlook | Leave a Comment »
Windows Explored 