My client has a small application which effectively, using Access VBA, copies an Excel template to a systematically named excel file, populates it, and then saves the destination excel workbook file. It hangs “randomly” , claiming it cannot find the renamed destination file, at copying time – one filesys copyfile statement – before it has been populated. The Access is running on 1 PC in a lan but the excel files are stored in the cloud – OneDrive. I think that the short process is too fast – sometimes – for the cloud to find /  create the destination excel file. I also discovered that a newly arrived Excel advice banner was a problem. I “upgraded” the original Excel template as advised and this issue disappeared. But the “can’t find” issue is not new. Any similar experiences?

​My client has a small application which effectively, using Access VBA, copies an Excel template to a systematically named excel file, populates it, and then saves the destination excel workbook file. It hangs “randomly” , claiming it cannot find the renamed destination file, at copying time – one filesys copyfile statement – before it has been populated. The Access is running on 1 PC in a lan but the excel files are stored in the cloud – OneDrive. I think that the short process is too fast – sometimes – for the cloud to find /  create the destination excel file. I also discovered that a newly arrived Excel advice banner was a problem. I “upgraded” the original Excel template as advised and this issue disappeared. But the “can’t find” issue is not new. Any similar experiences?  Read More

​