F
Frank Situmorang
Hello,
This is my VBA to copy it from desegnated folder to desegnated folder.
My question,
1. how can we make it to prompt us to copy from, then to desingnated folder.
2. From designated folder then to prompt us to copy to destination
Sorry, I do not know how to say it in English, but my intention is:
1 Prompt us from and destination is fixed
2. Prompt us for Destination and from/origin is Fixed.
This is my VBA for both origin and destination is fixed ( determined)
Private Sub SendtoOutbox_Click()
On Error GoTo Err_SendtoOutbox_Click
Call Shell("xcopy C:\Churchdata\BkEnd\Hahomion_be.mdb
C:\Churchdata\ChurchdataConso\BkEnd\Hahomion_be.mdb/y")
Exit_SendtoOutbox_Click:
Exit Sub
Err_SendtoOutbox_Click:
MsgBox Err.Description
Resume Exit_SendtoOutbox_Click
End Sub
Thanks very much
This is my VBA to copy it from desegnated folder to desegnated folder.
My question,
1. how can we make it to prompt us to copy from, then to desingnated folder.
2. From designated folder then to prompt us to copy to destination
Sorry, I do not know how to say it in English, but my intention is:
1 Prompt us from and destination is fixed
2. Prompt us for Destination and from/origin is Fixed.
This is my VBA for both origin and destination is fixed ( determined)
Private Sub SendtoOutbox_Click()
On Error GoTo Err_SendtoOutbox_Click
Call Shell("xcopy C:\Churchdata\BkEnd\Hahomion_be.mdb
C:\Churchdata\ChurchdataConso\BkEnd\Hahomion_be.mdb/y")
Exit_SendtoOutbox_Click:
Exit Sub
Err_SendtoOutbox_Click:
MsgBox Err.Description
Resume Exit_SendtoOutbox_Click
End Sub
Thanks very much