Thread: [Solved] Move individual files to various folders using VBA?
View Single Post
 
Old 01-12-2023, 01:47 PM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
You didn't mention OneDrive before, so the code was written assuming everything was on a local drive. In my testing (including with an external USB drive) it worked fine for that. Since OneDrive uses a url for the path behind the scenes, a different approach would be needed. A workaround would be to create an alias for the OneDrive folder on a local drive and use that.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote