Macro from Access Point

manojkulkarni — Thu, 29 Oct 2015 10:13:40 GMT

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

Re: Macro from Access Point

marcus_sommer — Thu, 29 Oct 2015 11:34:54 GMT

Try this:

...

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

...

- Marcus