Eport Visio imformation to Excel Doc

[bg_ie]

Hi,

I want to extract information from my visio doc and store it in a excel
doc. At the moment I am saving this info to a text file. How do a
create an excel doc from within visio using vbe?

Thanks very much for your help,

Barry.

 

[bg_ie]

(e-mail address removed) skrev:

Hi,

I want to extract information from my visio doc and store it in a excel
doc. At the moment I am saving this info to a text file. How do a
create an excel doc from within visio using vbe?

Thanks very much for your help,

Barry.

I've managed to find this doc which is very helpful -

http://www.design-drawing.com/visio/custprop2.htm

but, this method requires a reference to the Excel Object Model. If I
was to use this method and then send my macro to a customer, would they
have to select this reference also before my code would run? If so,
what are the alternatives?

Thanks for your help,

Barry.

 

[Al Edlund]

setting the reference requires the user(?) to open the document in developer
mode and apply the appropriate reference from there. (just as you did when
you put the macro together)
al

 

[Scott]

Another alternative is to use the Visio Report Wizard (Tools/Reports in
Vis2003; Data/Reports is Vis2007). The Wizard steps through the process of
selecting fields to export, and allows sorting, grouping and totaling
depending on the nature of your data. You can save the report definition in
your Visio document (it's saved in the Document shapesheet) so it will go to
your customer with the drawing.

Each time the report is run, you can choose one of our output types: Excel,
HTML, visio shape or XML. All are essentially the same tabular format written
out to the selected file type.

The customer can execute the report manually from the same menu you used to
create it or you can embed a macro that executes the reports. For some ideas