PowerShell – COM Programming – App – Word.Application – Day 01

  Outline Determine the Application ID for the Application's Com Object Example Microsoft Office Microsoft Word => Word.Application Issue [type]::GetTypeFromProgID against Application ID Links Link Issue [Activator]::CreateInstance against the retrieved type Links Link Retrieve the follow Object's Property Version Build BuildFull Path Code PowerShell Output Source Code Sharing GitHub Gist DanielAdeniji/ComObjectsThroughPowerShell.ps1 Link

Microsoft – Office – Outlook – Offline Mode

  Background This morning upon getting to work, noticed that my Microsoft Office Outlook had been placed in offline mode.   Troubleshooting Outline Is application in offline mode Status Bar Check status bar and see if it reads "Working offline" Top Bar - Ribbon Top Bar - Ribbon - Tab - Send/Receive The "Work offline" … Continue reading Microsoft – Office – Outlook – Offline Mode

Tableau – Public Edition – Installation

Background One of the Database Reporting tool we use at work is Tableau. Wanted to take another look at it. Found out that since the last time I looked at it, they have added a Free Edition; it is called Public. Artifacts The public edition is available for download here. Installation Installation is straight forward. … Continue reading Tableau – Public Edition – Installation

Microsoft – Access Database Viewer

Background Have a database that I need to review. Unfortunately it is a Microsoft Access Database and I do not have Access installed. And, so googled for opportunities. Sample Databases You likely want to try things out against sample databases before hand. Here are some sample databases that are available online. Microsoft Office Access 2010 … Continue reading Microsoft – Access Database Viewer

Error :- The Microsoft Access database engine cannot open or write to the file. It is already opened exclusively by another user, or you need permission to view and write its data.

Background Debugging an application and thankfully I have managed to add good exception handling. Error Here is the error message :- Error Image Error Text Remediation I watched the connection string over and over.  Installed the Database Connectivity driver and no good. Finally, I accepted the error message. Error Message :- The Microsoft Access database … Continue reading Error :- The Microsoft Access database engine cannot open or write to the file. It is already opened exclusively by another user, or you need permission to view and write its data.

Microsoft – Excel – SubTotals

Background I have a situation where I need to summarize some data and I don't really want to do so in a database.   SQL Server In Database we have roll-up and Windowing Functions. And, it is really likely the way I should go.   Excel But, as the data is not in a database, … Continue reading Microsoft – Excel – SubTotals