GTU previous years question papers
GUJARAT TECHNOLOGICAL UNIVERSITY
BE- Vth SEMESTER–EXAMINATION – MAY/JUNE – 2012
Subject code: 15 06
Subject Name: Visual Basic Application and Programming
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.
Q.1 (a) (i) Which are the functionalities of VBA? Explain All in details?
(ii) Give a short note on Event-Driven Programming?
(b) Explain All the VBA operators, its precedence in details with examples?
Q.2 (a) (i) Explain the Working of Range Object in VBA code for Excel Application?
(ii) Explain Check Box and Option Box.
(b) List out all the Date and Time Functions. Explain any seven functions in details with examples?
(b) List out all the Math Functions. Explain any seven functions in details with examples?
Q.3 (a) (i) Explain Multi-Dimension Array and Dynamic Array with examples?
(ii) List out all methods of MailItem Object for E-mail Messages?
(b) Explain the Handling of Incoming and Outgoing message using ItemAdd and ItemSend methods with example?
Q.3 (a) (i) Explain CreateObject method with its all Application Name and Object Type?
(ii) Write all cursor type and Lock types of Recordset in ADO database connection?
(b) Explain OPEN method with syntax of ADO recordset in details?
Q.4 (a) Explain Do…Loop and While…Wend in details with examples?
(b) Explain On Error statement in details with examples?
Q.4 (a) Explain For…Next, For Each…Next and If…End if conditions with examples?
(b) Explain MsgBox and InputBox in details with Examples?
Q.5 (a) (i) What is the Private and Public Procedures?Explain its Scope and syntax with examples?
(ii) Explain Selection Object in Word Application?
(b) Explain all the following methods of DOCUMENT Objects of word Application in details? [ Add, New, Open, Close, Save, SaveAs]
Q.5 (a) (i) What is the Function? Explain in details with examples?
(ii) Explain Range Object in Word Application?
(b) Explain Addnew,Update and Find Method of ADO Recordset with Example?
To download engineering ebooks, medical ebooks, management ebooks, free ebooks please visit www.kopykitab.com