hi,
i have a simple script that writes to a notepad file. if the file is already open, i don't see any updates unless i close the file and reopen it.
is there a way to check to see if the file is open, then close it and reopen it?
[VBA]Sub Test()
On Error Resume Next
Open "C:\testOpen.txt" For Append As 1
dat = Range("a1")
Print #1, dat
Close #1
End Sub[/VBA]
thanks
zach