thub.users.profile.tabs.comments.personalized


Thanks for your advice.

I understand that Dir function of VBA is not applicable to files on OneDrive Cloud.
I will try and test GetAbsolutePath Function in the FileSystemObject as your advice.

If I will have any result, will replay.

Many thanks.

Dear Viorel-1,

Yes, when changing code, as you advised, it works well.
The sub checks files saved on MyComputer folder rather than OneDrive folder, and so dir returns filename.
And then save file as OtherName, and it synchronized to MyComputer folder.
So sub works proferly as I expected.

When I work on MyPC, I think it may work without problem, because the process is reverse of 'first work in MyComputer ans sync to OnDrive.

However, when I connect OneDrive through other PC and run the mentioned sub then I think it may not work proferly.
May cause similar problem because there is no same folder and/or filethe in the other PC.
So I need to sole this problem.

Anyhow your advice is very helpful and interesting.
Thank you very much.