Problem with .Comment.Shape.Fill.UserPicture

Hi!

When I try to add pictures that are stored deep within the companys network structure with the command: Comment.Shape.Fill.UserPicture "FILE"

It gives me an error: "In data parameters are outside the interval" (Translated from swedish)

Is there a way to fix this? Pictures stored not so deep in the file structure works perfect.

Hello Peter223,

In your example you show "File". I assume that is the file name. The UserPicture method requires a fully qualified file path.

Example:
ActiveCell.Comment.Shape.Fill.UserPicture "C:\Program Files\ Pictures\Picture 1.gif"

I can't say for sure that this the problem based on your example and the translation of the error message. Perhaps it will point you in the right direction.

Sincerely,
Leith Ross

Hi

Yes I know it requires a file path, my problem was that when the file path is very long, I get an error.

I will probably solve it by checking the length of the path and ask the user to move the pictures if the pictures are in a too long file path.