From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.


Showing results for 
Search instead for 
Did you mean: 

excel vba script Write and Save




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.


Any ideas how can i save the vbproject ?




0 Kudos
Message 1 of 1