At the end of my procedure to upload an imported Excel file I want to copy/move the file to a different folder.
I have tried the following but get a "Path/File Access Error" reported from MS Access. I have debug on and know that the 'move to' folder string is being loaded correctly. Both path names appear to be valid and correct.
Any help is appreciated.
strPathFile is "C:\Access2007\Shop Material Import\excelsheet.xlsx"
strMovePath = Replace(strPathFile, "Shop Material Import", "Shop Material Uploaded")
FileCopy strPathFile, strMovePath