Category Archives: Office Automation

How To Change Connection Type In Power Pivot

Every day, day in and day out, the most popular posting I have here is this one: https://dmoffat.wordpress.com/2013/08/21/how-you-can-change-to-another-connection-type-in-powerpivot/ and this one: https://dmoffat.wordpress.com/2013/08/14/building-a-flexible-and-efficient-client-side-powerpivot-solution-in-excel-2013-2/ I personally use these techniques all the time, for years now and it is my standard modus-operandi for … Continue reading

Posted in Excel, Excel 2013, Office Automation, OLAP, Power BI, Power BI Desktop, PowerPivot, Process Automation, Spreadsheets, Uncategorized | 19 Comments

Is Power BI For Real ?

Thought of the day … I have been messing around with Power BI for a while now and while it “looks” great and does “good demo” I’m finding it almost impossible to build anything that I can rely on  .. … Continue reading

Posted in Analysis Services, Business Intelligence, Cloud, Excel 2013, Microsoft Access, Office Automation, OLAP, Power BI, Power BI Desktop, PowerPivot, Process Automation, Spreadsheets, the Cloud | Tagged , | 15 Comments

This post is about the Windows 10 Start Menu Corruption BS ….

I am going to talk about something that most users of Windows 10 have not run into yet, so most will probably be inclined to just write this post off as irrelevant to them .. Just wait !! This post … Continue reading

Posted in Access, Access Solutions, Business Intelligence, Excel 2013, Microsoft Access, Microsoft Access 2013, Microsoft Excel 2013, Office 2013, Office Automation, PowerPivot, Process Automation, Spreadsheets, the Cloud, Windows 10, Windows 10 Start Menu | 6 Comments

My Rules For Solution Engagements …

I’m baaaack … again … I have decided that I just cannot not blog … I have too many thoughts and I sure would hate to see all the knowledge I have accumulated disappear with me into retirement someday (or … Continue reading

Posted in Access, Access Solutions, Business Intelligence, Excel 2013, Microsoft Access, Microsoft Access 2013, Microsoft Excel 2013, Office 2013, Office Automation, PowerPivot, Process Automation, Spreadsheets, VBA | 3 Comments

Here We Go … REAL JavaScript Macros For Excel ?

I have been completely open and honest (as usual) about my contempt for the useless offerings that Microsoft has tried to pass for “Automation” in Excel using JavaScript.  Their concept of “Add-Ins” which do little more than allow you to … Continue reading

Posted in Analysis Services, Cloud, Excel, Office Automation, OLAP, PowerPivot, Process Automation, Spreadsheets, the Cloud, Uncategorized, VBA | 7 Comments

My Thoughts On Excel TV

Earlier this week I appeared on the Excel TV broadcast with Rick Grantham, Jordan Goldmeier and Oz du Soleil …  It was great fun for sure and I hope it was somewhat valuable to the broad Excel community (and even … Continue reading

Posted in Access, Access Solutions, Business Intelligence, Cloud, Excel, Excel 2013, Microsoft Access, Microsoft Access 2013, Microsoft Excel 2013, Office 2013, Office Automation, OLAP, PowerPivot, Process Automation, Spreadsheets, the Cloud, Uncategorized, VBA | 8 Comments

Changes In Procurement Practices Are The Death Of Us All …

Just replied to someone on LinkedIn in a  conversation about Access work getting really thin lately …  Thought my response might be a good blog .. (additions in blue) .. Jeff asked …”Has the market shifted to hiring contract programmers? … Continue reading

Posted in Access, Access Solutions, Analysis Services, Business Intelligence, Excel, Excel 2013, Microsoft Access, Microsoft Access 2013, Microsoft Excel 2013, Office 2013, Office Automation, PowerPivot, Process Automation, Spreadsheets, the Cloud, VBA | 2 Comments

Windows 10 – To Infinity and Beyond !!!

As I discussed here earlier the following has been officially announced by the MSM: http://www.bbc.com/news/technology-32658340 There are all kinds of implications of this – and one of them is NOT the death of Windows … quite the contrary.  Even if … Continue reading

Posted in Access, Access Solutions, Cloud, Excel, Excel 2013, Microsoft Access, Microsoft Access 2013, Microsoft Excel 2013, Office 2013, Office Automation, Spreadsheets, the Cloud, VBA | 5 Comments

Microsoft Excel And Azure RemoteApps … How About A Full-Featured Version Of Excel On Every Device?

I recently posted here about the opportunities for Access Developers in the Azure RemoteApps technology.  I know that it will cost your clients a bit more than the free ride they have been on with Access (some of them for … Continue reading

Posted in Analysis Services, Business Intelligence, Cloud, Excel, Excel 2013, Microsoft Excel 2013, Office 2013, Office Automation, OLAP, PowerPivot, Spreadsheets, the Cloud, VBA | Tagged , , , , , | 5 Comments

Access In The Cloud – Forever?

OK – here goes … 1. Have you and your business used Microsoft Access to help run your business for years ? 2. Are you pretty much completely happy with this Access solution and have invested a great amount of … Continue reading

Posted in Access, Access Solutions, Cloud, Microsoft Access, Microsoft Access 2013, Office 2013, Office Automation, Process Automation, Spreadsheets, VBA | 5 Comments