Kyle123
Previous post 1256542 refers
I have a macro that when the folder I need to loop through is on a local/network drive uses ...
‘MyFilePath = Dir(myPath & myExtension)
I now need myPath to be a OneDrive shared folder, but as far as I can gather, Dir will not work in that environment ...
But will the code you posted 31/12/2018 in the above post do the equivalent?
Bottom line, I need to loop through every *.xlsm file in the named OneDrive shared folder - open the file, extract the data, close the file, move the file to another OneDrive shared folder - and move to the next file in the named folder until there’s no files left ...
Thanks for any help in getting this to work ...
Bookmarks