automating "report" and "export to database"

H

helloImJean

hi all,

I have about two dozen pages in a visio file and somehow I could only export
one page at a time to an access database. is there anyway to export all data?

and my second question is, if it's possible to write an application that
automates both the report and export function in VBA.

Thank you very much for the help!

Jean
 
B

Barb Way

Yes - it is a page oriented function.
But it's fairly easy for you to update your code to 'walk' the pages and
perform the export on each page. Just get a reference to the drawing's
Pages collection, and you can perform actions for each "page" in "pages",
similar to this VBA snippet.

---------------------------------------------------
Dim PgCollection As Pages
Dim OnePage As Page

Set PgCollection = ThisDocument.Pages ' Get the
collection of Pages for the current drawing
For Each OnePage In PgCollection ' Get the
Page
'do something using OnePage
Next OnePage
---------------------------------------------------


Barb Way
Product Support - Visio
Microsoft Corporation
[This posting is provided "As Is" with no warranties, and confers no
rights.]
--------------------

hi all,

I have about two dozen pages in a visio file and somehow I could only
export
one page at a time to an access database. is there anyway to export all
data?

and my second question is, if it's possible to write an application that
automates both the report and export function in VBA.

Thank you very much for the help!

Jean
 
Top