New To VBA...Pls Help

[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.

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

Thanks

[lintz]

Is this what you're after?

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

[Matt_T_hat]

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.

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...??