export data to excel

[Jayson]

Hi

im quite new to using visio. im currently doing an office
plan and using the "office space" shape to determine the
amount of area in a certain office area. What i wanted to
know was if there a way to export the office space amount
it has calculated (eg 57sq metres) dynamicly to excel so
that when i resize the area on the plan the spreadsheet
updates.

thanks

 

[RA]

Yes, you can use the "Link to Database" functionality in Visio to export and
link the database values.
Highlight the shape
Click on Tools \ Macros \ Visio Extras \ Link to Database
Set the database source to the Excel sheet and complete the dialog.

When you resize the shape, you can right-click it and "Update database"

 

[Jayson]

I have done this but i cant seem to get the actuall
number/value of the sapce (metres sq), i have a formular
in the spreadsheet but cant seem make it equate it, the
number is in the user text but thats a bit a silly way of
doing it as it will show what number th user inputs for
the area.

-----Original Message-----
Yes, you can use the "Link to Database" functionality in Visio to export and
link the database values.
Highlight the shape
Click on Tools \ Macros \ Visio Extras \ Link to Database
Set the database source to the Excel sheet and complete the dialog.

When you resize the shape, you can right-click it and "Update database"


--
-ronnie
[MS]
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi

im quite new to using visio. im currently doing an office
plan and using the "office space" shape to determine the
amount of area in a certain office area. What i wanted to
know was if there a way to export the office space amount
it has calculated (eg 57sq metres) dynamicly to excel so
that when i resize the area on the plan the spreadsheet
updates.

thanks

.