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

We appreciate your patience as we improve our online experience.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

excel vba script Write and Save

Bugsy26_0-1695831660871.png

Hi,

 

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 ?

 

Regards,

Daniel

0 Kudos
Message 1 of 1
(314 Views)