how to show developer tab in microsoft office Excel
By bryan tugade
Do you want to develop in microsoft office environment? Let say you want to add buttons in microsoft excel, you can use the developer tab to create a vba applications. Developer tab is hidden by default in microsoft office. You can show this tab in less than a minute. Here's how.
Related FAQs
Do you want to develop in microsoft office environment? Let say you want to add buttons in microsoft excel, you can use the developer tab to create a vba applications. Developer tab is hidden by default in microsoft office. You can show this tab in less than a minute. Here's how.
Let say you need to develop an application that incorporate sql database to your Visual basic application(vba) in microsoft excel. So you open a workbook in excel then enabled the developer tab and go to vba window. But unfotunately when your creating a variable to instantiate the adodb, it doesn't show in the intellisense. Do you know why?
It is because you haven't add the microsoft activex data objects 2.8 library to your references.
Here's how to add it to your references.
Assuming that you need to create an application that needs to transfer data from sql server to microsoft excel. The first thing you need to do is to find a way to connect to sql server. We can do this by using visual basic application.
Have you try to transfer your data fro SQL Express to Microsoft office excel? What if your company wants you to get all the data from
your database and put it in excel. Theres two way i know how to do it. Here it is.
how to show developer tab in microsoft office Excel (305 Views)