Nothing to do with windows media player. My excel code would not move an mp3 file if it were written as MP3. I would like to say I found the problem but a member of an Excel forum told me
smiler44
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
What properties/attributes of a mp3 file could stop an Microsoft Excel macro moving the mp3 file?
I have a macro that played the mp3 file and some 500 other mp3 files and then moved them to another directory but the Excel Macro to move all the mp3 files back to the original directory failed to move 2 mp3 files. I have run it again to just move the 2 files and it again failed to move them.
thank you in advance
Nothing to do with windows media player. My excel code would not move an mp3 file if it were written as MP3. I would like to say I found the problem but a member of an Excel forum told me
smiler44
Hi,
You can try these steps to troubleshoot the issue: first, check if the two MP3 files are still being used or locked by Windows Media Player since even after playback stops, the file handle may remain open and prevent Excel from moving the file. Second, right-click the files and check their Properties > Security tab to ensure your user account has full control permissions. Third, verify the files aren’t marked as Read-only or Blocked (under Properties > General, look for an “Unblock” button). These small attributes can interfere with file operations in VBA.
Can you confirm if the two files can be moved manually using File Explorer? Also, do these MP3s have any special characters or unusually long file paths that could be causing Excel’s Name or FileSystemObject move command to fail?
Kind regards,