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 ...