My Blog

Opening Word Document in Print Layout

Recently my office upgraded from MS Office 2010 to MS Office 2013 and my VB.Net code started breaking on the line The problem was in MS Office 2013, the view prevented me from writing anything to the document as shown below. I experimented with MS Word Menu File | Options, but couldn’t get it to work and then I realized …

Read More

Button Less Excel Msgbox

I have been thinking about it quite a bit for a very long time now. Msgbox in VBA doesn’t give you an option to hide it’s button. But we can bypass by subclassing the Excel Application and the Message Box. The question which forced me to finally work on it is posted in StackOverflow. I am going to demonstrate only …

Read More

Format numbers in Excel TextBox as you type

VBA doesn’t have what you call a Masked Text Box where you can set formats as #,##0.00. You can only do a masked textbox for accepting passwords but that is altogether a different thing. Here is something I quickly came up with. Hope this helps someone? You can also take it to a slightly higher level by including this code …

Read More

Open Excel File and Read Data using ACE

In continuation from here… Now that we have learned how to create an Excel File using Ace and write data to it, let’s now try and read from it. We will read the data from the file that we created in the previous section Let’s create a button in the form that we created and name it Open. And now …

Read More

Creating a New Excel File and Adding Data using ACE

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

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
Page 1 of 1312345»10...Last »