
VBA - Write To File - Simple Log File!
Thanks Alot Dan!
To be honest, i can belive how simple the process is!
i thought i'd need Declairations and calls to "Kernal32" and all sorts..
I'm now writing Successful LogFiles for all Logable Events! :-)
Thanks
Jado
Quote:
> Hi Jado,
> Here is how to write to a file:
> Dim strOut As String
> strOut = "test"
> Open "C:\myLog.txt" For Append As #1
> Print #1, strOut
> Close #1
> HTH
> Dan Artuso, MVP
> > Hi,
> > I'd like to create a simple log file that records some of the Key Events
> > that take place in my database during the day.
> > Could someone provide a simple sample of how to do this, as i wouldn't
know
> > where to strart!
> > Thanks
> > Jado