What should you do?

You create an Office Visio 2007 drawing. The drawing stores data in a Microsoft Office Excel 2007 spreadsheet. You need to add VBA code to the drawing to access the Excel spreadsheet. What should you do?

You create an Office Visio 2007 drawing. The drawing stores data in a Microsoft Office Excel 2007 spreadsheet. You need to add VBA code to the drawing to access the Excel spreadsheet. What should you do?

A.
Add a reference to the Excel object library, and then add the following code to the drawing. Set xlApp = CreateObject ( Visio.Application )

B.
Add a reference to the Excel object library, and then add the following code to the drawing. Set xlApp = CreateObject (” Excel.Application “)

C.
Add a reference to the Visio object library, and then add the following code to the drawing. Set xlApp = CreateObject (” Excel.Application “)

D.
Add a reference to the Visio object library, and then add the following code to the drawing. Set xlApp = CreateObject ( Access.Application )



Leave a Reply 0

Your email address will not be published. Required fields are marked *