PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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