O'Reilly logo

Professional Development with Visio® 2000 by David Edson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Querying Excel for Visio's Use

Here is an example of sending information to an Excel spreadsheet that is an inventory of all the furnishings in an executive office. Each Visio SmartShape symbol used as a furniture item has a custom property “Inventory.” Only those items that have this property are passed to Excel. The application is launched via an ActiveX control on the Visio page. This example can be found on the companion CD-ROM as OfficeExcel Ch21,VSD.

Figure 21.1. Executive office drawing.

Listing 21.3. Passing Data to Excel
 Private Sub CommandButton1_Click() Call RunInventoryToExcel End Sub Public Sub RunInventoryToExcel() Dim szMessageString ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required