G
Girija
How can I export the Visio Shape Data to excel using a macro? Any samples
will help
Thanks
will help
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
AlEdlund
There are several ways. Have you looked at the database wizard for export?
al
al
J
John... Visio MVP
Girija said:How can I export the Visio Shape Data to excel using a macro? Any samples
will help
Thanks
Run a report
John... Visio MVP
G
Girija
Yes. But reports does not give you control over which spreadsheet to import
the data to.I wanted to write a macro to export shape data into an existing
spreadsheet
and be able to overwrite just the required cells. Using the data export
wizard also did not help as it overwrites the existing spreadsheet. The
target spreadsheet has other data which I want to retain.
the data to.I wanted to write a macro to export shape data into an existing
spreadsheet
and be able to overwrite just the required cells. Using the data export
wizard also did not help as it overwrites the existing spreadsheet. The
target spreadsheet has other data which I want to retain.
A
AlEdlund
Then you might start over here for an example of exporting to excel,
http://msdn.microsoft.com/en-us/library/aa140253(office.10).aspx
al
http://msdn.microsoft.com/en-us/library/aa140253(office.10).aspx
al
G
Girija
Appreciate your time. This will certainly help. Thanks