Claus Busch wrote:

Hi Terry,

Am Fri, 15 Dec 2017 08:48:11 +0000 schrieb Terry Pinnell:

Run-time error '5':
Invalid procedure call or argument

The line highlighted by Debug was this:

Set objFolder = FSO.getfolder(MyPath)

you can try the code in an empty sheet also.
But make sure you have the path in A1 (e.g.: G:\myvideos\)
Regard the backslash at the end of the path.
With the macro you don't need file names or hyperlinks in column F
because the code writes new hyperlinks for all files in the path's
folder and subfolders and the size in column G.

If you only want the size of the existing files in column F use Garry's
code.


Regards
Claus B.

Oh, I see, thanks for clearing that up Claus. I totally misunderstood.

Yes, I do want to retain the structure of my large and quite complex
existing workbook, so I'll use Garry's code.
https://www.dropbox.com/s/slfzuoljpj...dex-1.jpg?dl=0

I click on the hyperlink col, F, to open that video. And col G shows me
its size, useful in various ways such as for deciding what uploads to
Vimeo I can make within my upload limit this week.

--------------------

BTW, digressing a bit, when I click the hyperlink I always get an
irritating warning message, It's quite redundant as these are videos
I've created myself, stored on my PC. I've been trying in vain to
discover how to get rid of it!
https://www.dropbox.com/s/utgmnyafff...ssage.jpg?dl=0

I've tried various registry hacks as well as the Trust Center settings
but still no success. So if anyone here has any solution...

This is Win 10 with Excel 365, so I'd be interested to know if others
get the same.

Yes, it's only one extra click, but it just seems so daft that I cannot
silence it!

Terry, East Grinstead, UK