How to get the name of the background currently displayed in Excel?

Hello,

I have a macro in VBA that is on loop and cycles between many pictures I have in a folder as backgrounds for my spreadsheet.
I would like if possible to get the name of the background currently displayed so it writes it in a cell of the spreadsheet.

How could I do that?
Thanks

Here is the vba code:

Please Login or Register  to view this content.

I have done some research on this and there does not appear to be any built-in property that can tell you the name of the file you used to set the background. However, since you are setting the background in your code, why not just add a line of code to show the file name in a cell at the same point where you set the background?

Please Login or Register  to view this content.

Let's try this:

Please Login or Register  to view this content.

Change this declaration as follows

Please Login or Register  to view this content.

The way it is declared is Variant, but it is used only as a String so should be declared as String. Also, the Sub expects a String argument so now it will match.