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 549 Downloads 273

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

ANmarAmdeen
333
Attachments
File System VBA-Excel
Revisions

v1.0

Needs