Save connected data back to excel after change in shape

Started by martin, February 27, 2014, 09:48:54 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

martin

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


Yacine

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".
Yacine