Permission Denied error

Issue: Trying to copy file (Using VB command FileCopy) while that file was opened by another app (or user)

Trying to run "FileCopy" while source file is open can generate error
Permission denied

Fix: While if we do that using FSO, we can easily copy it with no issues

Found: During trying to copy csv file that was open in Excel by another user on a network drive

Views 240 Downloads 86

'FSO', 'Error', 'permission', 'denied', 'permission denied', '70', 'vba', 'macros', 'filecopy', 'FSP', 'copy', 'csv', 'access'

ANmarAmdeen
324
Attachments
File System VBA-Excel
Revisions

v1.0

Needs