Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
developer
active.documents
automation
binary.file_format
clipboard.dde
com.add_ins
hosting.controls
internet_other
office.sdks
officedev
officedev.other
outlook.forms
outlook.vba
smarttags
vba
web.components
  
 
date: Mon, 4 Aug 2008 15:46:50 +0200,    group: microsoft.public.office.developer.outlook.vba        back       


log file   
Dear All,

I'd like to know how can I do to write a log file as a result of 
errors/warnings in Outlook Macro / VBA


                                                    Kind Regards

                                                    Alberto Brivio
date: Mon, 4 Aug 2008 15:46:50 +0200   author:   Alberto Brivio

Re: log file   
Here's a simple example for how to write a file:
http://www.vboffice.net/sample.html?pub=6&mnu=1&smp=14&cmd=showitem&lang=en

This might work for you:

Sub Example()
	On Error goto ERR_HANDLER:
	'...your code
	Exit Sub
ERR_HANDLER:
	WriteFile Err.Description & vbcrlf
End Sub

-- 
Best regards
Michael Bauer - MVP Outlook

  : VBOffice Reporter for Data Analysis & Reporting
  : Outlook Categories? Category Manager Is Your Tool
  : <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Mon, 4 Aug 2008 15:46:50 +0200 schrieb Alberto Brivio:

> Dear All,
> 
> I'd like to know how can I do to write a log file as a result of 
> errors/warnings in Outlook Macro / VBA
> 
> 
>                                                     Kind Regards
> 
>                                                     Alberto Brivio
date: Mon, 4 Aug 2008 21:45:26 +0200   author:   Michael Bauer [MVP - Outlook]

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us