I have this piece of code which i'm using to write in a visual project sheet of an .xlsm file.
I manage to write the value (as you can see in the .png) in the desire vbproject, but i can't save the changes. What property should i use ? I'm saving the workbook, at the end it is mentioned that it is saved, but when i opened it, is still empty.
The property disabled from the code requires a FileName string and i didn't manage so far to get the FileName from anywhere.