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 211 Downloads 79

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

ANmarAmdeen
323
Attachments
File System VBA-Excel
Revisions

v1.0

Needs