I created a Maco using RunSavedImportExport this works but if the file exists I the the pop window file exists is is ok to replace. I don't want to have any prompts is there a way to always replace file if it is there?
I created a Maco using RunSavedImportExport this works but if the file exists I the the pop window file exists is is ok to replace. I don't want to have any prompts is there a way to always replace file if it is there?
I use only VBA, don't know if there is macro equivalent. Review http://www.rondebruin.nl/folder.htm
I use this code to copy/replace file:
Set objFSO = CreateObject("Scripting.FileSystemObject")
objFSO.CopyFile "sourcepath\filename", "destinationpath\", True
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.