Category Archives: VBA

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

Microsoft Says What They Really Think

Thanx to Debra over at Contextures for letting me know about this presentation from the Office 365 Garage Series: http://blog.contextures.com/archives/2014/07/28/excel-roundup-20140728/ What we’re seeing here is an open statement by Microsoft that full-featured client Office is dead and that we must all … Continue reading

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

The Microsoft Rapture

Read this link before reading my comments here: http://www.geekwire.com/2014/internal-memo-microsoft-cut-external-staff-18-months-requiring-six-month-break/ I believe that this (even more than the 18000 announced last week – most of whom are at Nokia) will force a HUGE reorg of Microsoft before the end of 2014 … Continue reading

Posted in Access, Analysis Services, Business Intelligence, Excel, Excel 2013, Microsoft "V-", Microsoft Access, Microsoft Access 2013, Microsoft Excel 2013, Office 2013, Office Automation, OLAP, PowerPivot, Spreadsheets, Uncategorized, V-, VBA | 4 Comments

Data Access Is STILL The Problem

Below is a replay of a posting I made here waaaay back in 2011.  It discusses an issue that is not only STILL a problem for people trying to help businesses analyze their data but that is now exponentially worse … Continue reading

Posted in Access, Analysis Services, Business Intelligence, Excel, Excel 2013, Microsoft Access, Microsoft Access 2013, Microsoft Excel 2013, Office 2013, Office Automation, OLAP, PowerPivot, Spreadsheets, VBA | 6 Comments