Why is Excel VBA executing a command corretly in debug modus but not in normal mode?

So like the headline says: Why is Excel VBA executing a command correctly if I run it in debug modus, but in "normal" modus it does nothing?

It is about the command:

Please Login or Register  to view this content.

Try to wait some time so it can execute properly.
This will wait 2 seconds but try few time and adjust for yourself:

Please Login or Register  to view this content.

Also, please use code tags around your code as per forum rules. I've edit now for you.

You can try with FileLen function:

Please Login or Register  to view this content.

test size before executing Shell.
Then try for some different lenght how many time each file size need to upload.
If you can determine needed time comparing to file size you can adjust Wait function.

Add few seconds just in case but even that won't guarantee that it will work each time because your speed can vary.

The problem is that the filesize is not linear proportional to the upload time. E.g. If the i-net connection is slow it takes much longer to upload. Is there another way to let excel vba execute the command properly no matter how long the upload takes?

Yes, I know.
Are you uploading lot of files one after other or just few?

Just one file 2 times with a size of maximum 200mb. But the upload time can vary very much... it can take up to 30 minutes...

I would still make this corelation and then you can have one dummy file (let say 2MB) that will be uploaded first and then aproximate for those largest files.

Or just put 1 hour and let it over night to upload