Macro from Access Point

[manojkulkarni]

Hi friends,

I am using below code in a macro, macro is being triggered by Button Action. Below code executes only once when i trigger event from Access point .

Dim fso, f1

   Set fso = CreateObject("Scripting.FileSystemObject")

  Set f1 = fso.CreateTextFile("C:\Test.txt", True)

    f1.Write ("writing to text file")

f1.Close

[marcus_sommer]

Try this:

...

Set f1 = fso.OpenTextFile("C:\Test.txt", 2, true)

...

- Marcus