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

[Janna One Trick]

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.

[6StringJazzer]

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.

[Janna One Trick]

Ha yes indeed it works as intended! Thank you!

Is there a way to only show the name of the file without the extension?

It currently displays the full path and the extension:
D:\Backgrounds\name.jpg

How to make it display only "name"?

[Artik]

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.

When you insert an image as the sheet background, Excel saves the file with its own internal name. Does not store the name of the source file. The image is stored in an internal folder \xl\media\ with a name such as image1.png. In the internal file \xl\worksheets\_rels\sheet1.xml.rels we find relation Id and path to image , e.g.

Please Login or Register  to view this content.

In the file \xl\worksheets\sheet1.xml we find the relation:

Please Login or Register  to view this content.

.

Artik

[6StringJazzer]

Let's try this:

Please Login or Register  to view this content.

[Janna One Trick]

It is strange, it gives an error:
https://i.gyazo.com/552b4d9c5ef8caa2...baff5627e1.png

[6StringJazzer]

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.