A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

first start of OL2007 macro VERY slow - how can I fix this?



 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #10  
Old May 9th 08, 03:06 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default first start of OL2007 macro VERY slow - SOLVED.. sort of

Ditto. I like getting the prompt at startup. It lets me know for sure that VBA did indeed kick in.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Ken Slovak - [MVP - Outlook]" wrote in message ...
What I was thinking of wasn't registering it using IE, but after creating
the selfcert and setting the VBA project to use that cert to see if it shows
up in the trusted publishers list under Trust Center.

To tell the truth I usually set my macro security to prompt rather than
using a certificate. In my experience there are problems when you sign the
VBA project, like if you sign it and then change it and re-sign you get tons
of prompts to save. It was really bad on Outlook 2003 and earlier, so I got
out of the habit of signing the code.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"Dan" wrote in message
...

"Ken Slovak - [MVP - Outlook]" wrote in message
...
I'm not positive, but my guess is that the extra time with the selfcert
certificate is an attempt at validation from a certificate root
authority.

I'd be curious if you add the selfcert certificate to your trusted
publishers list if that helps at all.


hi ken,
that's what I tried. I believe I mentioned it below as well..
I exported the selfcert certificate, deleted it and then importet it into
the Trusted Root Certification Authorities Store. that actually works (I
was a little surprised on that). I could even select it in the VBA editor
as digital signature. then I exit the VBA editor, still no complaint from
Outlook.

But as soon as I exit Outlook, it just tells me that there was a problem
and that it removed the digital signature.. I don't recal the exact pop up
message, though.

dan


 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook Macro using SendKeys in OL2007... Default User Outlook - General Queries 2 May 30th 07 06:05 PM
OTL 2007 slow first start Drasko Outlook - General Queries 0 May 4th 07 08:56 PM
Outlook slow to start. Rob Outlook - General Queries 7 July 29th 06 12:27 AM
Outlook 2003 slow to start Mike_C Outlook - Installation 0 February 6th 06 07:40 AM
Outlook very slow to start on one machine, not on other Gary Hillerson Outlook - General Queries 1 January 18th 06 10:32 AM


All times are GMT +1. The time now is 11:39 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.