Hi,
does anyone know how I can write back data from a shape to the connected excel.
ex:
I have a excel with the lines
1 | Test
2 | Test
...
I connect this to visio, showing shapes.
Now in the Visio shape I change the Data. (1 | Test --> 1 | Foo)
Is there a way to save the changes back to excel?
excel after save:
1 | Foo
2 | Test
Perhaps I'm searching for the wrong keywords but I couldn't find an answer to this.
Thx,
Martin
No ideas?
Hi Martin,
posts come in so frequently, that the one or the other just gets overseen.
Sure, you can write your data back to Excel.
The question is how proficient you are in Visio, how automated it needs to be, ...
The most simple way, would be to setup a report that exports your data to excel. You would then manually exchange the data in the orignal file.
More elegant, but involving some coding, would be a macro that opens the excel file, iterates through all your shapes, writes the data to excel, closes the file and say "done".