New To VBA...Pls Help

Hello, I am wanting to sent the appointment item to a folder if the user has checked a check box. Could someone pls give me an example.

Code:

---

Function Item_Write()
    If chkPublish.Value = True Then
        ' Not sure what goest here...
    End If
End Function

---

Thanks

Is this what you're after?

Code:

---

FileCopy "C:\FileName.txt", App.Path & "\FileName.txt"
MsgBox "File Copied"

---

Quote:

---

Originally posted by mpSmooth
Hello, I am wanting to sent the appointment item to a folder if the user has checked a check box. Could someone pls give me an example.

VB Code:

Function Item_Write()
    If chkPublish.Value = True Then
        ' Not sure what goest here...
    End If
End Function

---

• Is This Access or Excel?
• Would a Public Sub WriteIt() be better or do you need to pass a message back?
• What are you useing to track the different (records?) things...??