My Blog

Creating a New Excel File and Adding Data using ACE

0

In continuation from here… Click on File and click on New Project. Under Visual basic, Select Windows and then select Windows Form Application. Give the project an appropriate name and select a location where you want to save this project. When the project opens you will be presented with Form1. For the time being just lets create 2 buttons and …

Read More

Ace OLEDB data provider download and Installation

0

DOWNLOAD Microsoft Access Database Engine 2010 Redistributable can be downloaded from the Microsoft’s Download Center Depending on 32bit or 64bit, you can download either the AccessDatabaseEngine.exe or the AccessDatabaseEngine_x64.exe. In this blog, I would be working with the 32bit version. If you already have MS-Access installed on your system then you do not need to download the above. It would …

Read More

Microsoft MVP : Re-Awarded

0

It’s that time of the year again when I was patiently waiting for a mail from Microsoft! Even though I am traveling to Leh and the connectivity is too low but the suspense was killing me. Phew!!!! Finally I could check my email on iPhone and was immensely pleased to see this… Dear Siddharth Rout, Congratulations! We are pleased to …

Read More

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
Page 1 of 1212345»10...Last »
Como comprar viagra por internet. Viagra femenina. . cheapest payday loans online within one day . Payday loans online lenders in California