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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top