Comments for Code For Excel And Outlook Blog http://www.codeforexcelandoutlook.com/blog Automation and interop VBA code samples for MS Excel and Outlook Fri, 30 Oct 2009 14:33:54 -0400 http://wordpress.org/?v=2.8.5 hourly 1 http://www.codeforexcelandoutlook.com/blog/http://www.codeforexcelandoutlook.com/logos/gray.gifLogocodeforexcelandoutlook/commentshttp://feedburner.google.comSubscribe with My Yahoo!Subscribe with NewsGatorSubscribe with My AOLSubscribe with BloglinesSubscribe with NetvibesSubscribe with GoogleSubscribe with Pageflakes Comment on Create Outlook contacts in bulk using VBA automation by TCox http://www.codeforexcelandoutlook.com/blog/2009/01/create-outlook-contacts-in-bulk-using-vba-automation/#comment-964 TCox Fri, 30 Oct 2009 14:33:54 +0000 http://www.codeforexcelandoutlook.com/blog/?p=463#comment-964 I wrote something similar in Perl about 7 years ago and this was so much easier. I tweaked the fields a little bit and was able to load 180 contacts in 5 seconds. Thanks! I wrote something similar in Perl about 7 years ago and this was so much easier. I tweaked the fields a little bit and was able to load 180 contacts in 5 seconds. Thanks!

]]> Comment on On Being a Responsible Outlook user by JP http://www.codeforexcelandoutlook.com/blog/2009/10/on-being-a-responsible-outlook-user/#comment-963 JP Fri, 30 Oct 2009 11:19:56 +0000 http://www.codeforexcelandoutlook.com/blog/?p=745#comment-963 Even from otherwise normal people ;) Even from otherwise normal people ;)

]]> Comment on On Being a Responsible Outlook user by Ken Puls http://www.codeforexcelandoutlook.com/blog/2009/10/on-being-a-responsible-outlook-user/#comment-962 Ken Puls Thu, 29 Oct 2009 22:00:14 +0000 http://www.codeforexcelandoutlook.com/blog/?p=745#comment-962 "To me, it seems like an organizational disease or culture problem when you have to resort to blocking the feature at the Exchange level." To me it seems like a training issue and lack of common sense. It's amazing how often you see it though. "To me, it seems like an organizational disease or culture problem when you have to resort to blocking the feature at the Exchange level."

To me it seems like a training issue and lack of common sense. It's amazing how often you see it though.

]]> Comment on Calculate Working Hours in VBA by Whitney http://www.codeforexcelandoutlook.com/blog/2008/06/calculate-working-hours-in-vba/#comment-961 Whitney Thu, 29 Oct 2009 15:37:12 +0000 http://www.codeforexcelandoutlook.com/blog/?p=67#comment-961 Hi, Can this formula be modified to calculate a work day of 8:00am until 5:00pm excluding lunch time from 12:00pm to 1:00pm? Thanks, Whitney Hi,

Can this formula be modified to calculate a work day of 8:00am until 5:00pm excluding lunch time from 12:00pm to 1:00pm?

Thanks,
Whitney

]]> Comment on HTML Object Libraries by JP http://www.codeforexcelandoutlook.com/blog/2008/02/html-object-libraries/#comment-960 JP Thu, 29 Oct 2009 00:21:41 +0000 http://jimmypena.wordpress.com/2008/02/20/html-object-libraries/#comment-960 If the website provides an API for extracting information, you should contact them for details on how to access it. Otherwise, if you have to use IE, you'll have to look at the results page after you submit the form. Start by viewing the source (View > Source) and look at the field names to see which ones you should be extracting from. If the website provides an API for extracting information, you should contact them for details on how to access it. Otherwise, if you have to use IE, you'll have to look at the results page after you submit the form. Start by viewing the source (View > Source) and look at the field names to see which ones you should be extracting from.

]]>