"Comment.Shape.Fill.UserPicture" CHARACTER LIMIT?

[MeiR_ct]

I have a VBA macro that fills pictures in comments (based on the famous link: http://www.contextures.com/xlcomments03.html#PictureFile)
Using Excel 2002 (XP), running on Windows XP Professional.

I've found out that if the picture path in "UserPicture" method is above 99 characters, the macro won't fill any picture in the comment (also when using a variable to store the path).
You can easily reproduce it with subfolders and LEN() function, it in order to verify.

Is there any way to bypass it?
I have plenty of picture folders, which I use for my work, and many of them are located in long paths.
Should I really start moving them one by one to a shorter path?

Hope there's a simple solution.

Thanks in advance,
Meir.

 

[tlowry]

Oh boy! Blame Herman Hollerith and the 80-column punch card he invented.


I’m using Windows 7 and it won’t let me setup a path with more than 80 characters.