Microsoft Office

This category contains information relating to Microsoft Office

Word 2007 and 2010 Crop Settings

0
1 year ago
in
Yesterday I was trying to split an image into 9 separate parts using Microsoft Word 2010, so I could print them out, and when put together would be about the same size as an A2 piece of paper. But I just could not work it out!!! In Word 2007, the settings were straight forward. Just specify the [...]

Remove HTML Tags and Escape Codes from an Excel selection

0
2 years ago
in
The code below can be used to remove HTML tags and escape codes from an Excel selection.  Simply page the code into a new module, select the relevant cells to be processed, and press run. I would suggest that you copy the original cells to another sheet and then try it on the copy first, just to [...]

Error “HRESULT 0x800A03EC” when outputting data to Excel

2
3 years ago
in
Sometime ago, I wrote a Query Tool application that output data from a database into Excel.  However, in the past few days, the users have been getting the “HRESULT 0x800A03EC” exception error when running a specific query. I knew that the application was working, because other query data was being [...]

MS Access – Remove “dbo_” prefix from imported tables

0
3 years ago
in
The procedure below, can be used to remove the “dbo_” prefix from all imported tables within a Microsoft Access Database. Public Sub Remove_DBO_Prefix()       Dim obj As AccessObject     Dim dbs As Object       Set dbs = Application.CurrentData       'Search for open AccessObject objects in [...]

The ‘Microsoft.Jet.OLEDB.4.0′ provider is not registered on local machine

0
3 years ago
in ,
I was in the middle of writing an application to retrieve the list of Access Database Tables, but I was getting the error “The ‘Microsoft.Jet.OLEDB.4.0′ provider is not registered on the local machine.” I discovered, that as I was using Vista x64, I needed to change the “Advanced Compiler Options” [...]
Go to Top