How to reset the VBE windows to their default positions
If you have some troubles with macro and projects explorer windows settings, after some bad manipulations. How to reset the VBE windows […]
How to disable "There's already data here. Do you want to replace it?" warning
When you drag any cell with data and drop it on any other cell with data, you will get the warning, "There's […]
Excel VBA: How To Remove Document Inspector Warning Include Personal Information
You may get warning message about the Document Inspector when you want to save Excel file. Is there a script can remove […]
The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine
For example, you have a 32-bit application (VBA, web app...) that uses the Microsoft OLE DB Provider for Jet. If you migrate […]
Microsoft Query Error: "This data source contains no visible tables."
When you import data by using the Microsoft Query Wizard and choose Excel Files as data source, you may receive the following […]
How To Correct Excel Formula Errors
This post teaches you how to correct Excel formula errors. Correct common errors in formulas Start every function with the equal sign […]