My Blog

What is Ace OLEDB data provider

1

This OLE DB Provider is provided by Microsoft and is contained in the file ACEOLEDB.DLL. The Microsoft ACE OLEDB 12.0 provider can be used to connect to many data sources like MS Access, Foxpro, Excel, Sharepoint Etc. This driver was first released with MS Office 2007 but that doesn’t mean that you cannot use this to connect with Pre-2007 office …

Read More

Microsoft MVP : Re-Awarded

4

Just switched on my mobile after getting off the plane and got this wonderful email… Dear Siddharth Rout, Congratulations! We are pleased to present you with the 2013 Microsoft® MVP Award!…… I am sure elated as this is the third time in succession I’ve been given this award. I would like to convey my heartiest thanks to the following 1. …

Read More

Find Excel’s VBE Command Bar names and built-in controls IDs. – VBA and VB.Net

1

As requested by Eric in the comments of this post, here is a code that I wrote couple of years ago which can help you in finding the Control Ids of VBE Menu. VBA Open the VBE and insert a Module as shown below. Once the module is inserted, it will look like this. Copy the below code and paste …

Read More

Unprotecting VBA Project Password (Using a password that you know)

19

First things first. This is NOT about hacking the VBA Project Password. If you have landed on this page to expect to see how it is hacked then I would recommend you to search somewhere else. This article is about unlocking the VBA Project password if you KNOW the password. Recently while answering a question in stackoverflow, I came across …

Read More

Excel Inputbox Automation from VB.NET

0

While answering a recent question in stackoverflow, I came across this question. These are the conditions that I used during testing VB.Net 2010 Ultimate 64 bit / Win 7 64 Bit / Excel 2010 32 Bit Inputbox was launched in Excel using InputBox (and not Application.InputBox) Sample Code to Launch the Excel InputBox Logic that I followed for both tests …

Read More

Calling Excel Worksheet Formulas from VB.Net

0

In continuation from here… What are Worksheet Formulas? A formula is an equation that analyzes data on a worksheet. They perform operations such as addition, multiplication, division, concatenating values etc. The formulas can refer to other cells on the same worksheet, cells on other sheets in the same workbook, or cells on sheets in other workbooks. Why do we need …

Read More
Page 1 of 1112345»10...Last »
buy followers on instagram with credit card . Order high quality essay writing services on any topic by skilled writers right now . Professional buy essay online.