EXCELLERANDO.BLOGSPOT.COM
ExcellerandoA programmer's scrapbook devoted to Microsoft Excel and its embedded language, Visual Basic for Applications.
http://excellerando.blogspot.com/
A programmer's scrapbook devoted to Microsoft Excel and its embedded language, Visual Basic for Applications.
http://excellerando.blogspot.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Thursday
LOAD TIME
0.3 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
19
SSL
EXTERNAL LINKS
0
SITE IP
216.58.195.65
LOAD TIME
0.289 sec
SCORE
6.2
Excellerando | excellerando.blogspot.com Reviews
https://excellerando.blogspot.com
A programmer's scrapbook devoted to Microsoft Excel and its embedded language, Visual Basic for Applications.
excellerando.blogspot.com
Excellerando: January 2015
http://excellerando.blogspot.com/2015_01_01_archive.html
Sunday, 25 January 2015. Trusted Locations: a source of misleading error messages. When's the last time you ran some VBA that opened a spreadsheet over the network? Or even on your own local temp folder? If you're working in Office 2010 or 2013, you might just have seen this error message:. Office has detected a problem with this file. To help protect your computer this file cannot be opened. You *might* see a message about content disabled, or the 'Trust Centre'. Application.ShowStartupDialog = Fals...
Excellerando: September 2014
http://excellerando.blogspot.com/2014_09_01_archive.html
Thursday, 18 September 2014. A Horrible Hack: Complex SQL Queries on Excel Data. A Cautionary Tale of things that no developer should ever see or do, with diversions and digressions into failures of business logic, workarounds and worse-arounds, budget fairies, business analysts, and scrofulous pilgrims seeking miraculous healing in the elevator lobby. Well, the answer to that is: "It's a prototype, and it's on the stack for the database developers to get it done properly". Except that it's still running...
Excellerando: July 2012
http://excellerando.blogspot.com/2012_07_01_archive.html
Saturday, 21 July 2012. A generic VBA Array To Range function. Here's a common task: writing an array to a range. Here, we're writing an array to the sheet in a single 'hit' to the sheet. This is much faster than writing the data into the sheet one cell at a time in lops for the rows and columns. However, there's some housekeeping to do, as you must specify the size of the target range correctly. As always, watch out for 'helpful' reformatting by your browser (or by Blogger) that inserts line breaks.
Excellerando: August 2012
http://excellerando.blogspot.com/2012_08_01_archive.html
Sunday, 19 August 2012. Join and Split functions for 2-Dimensional arrays. Here's something I fished out of the attic and posted into StackOverflow. The code's trivial, in the sense that anyone can do a bit of string-concatenation and a Redim() statement and you've probably done some kind of 'Join' and 'Split' already. But there are a couple of points about efficient string-handling in the comments; or rather, overcoming the inefficiencies of a language which has no string-builder class. The biggest perf...
Excellerando: A Horrible Hack: Complex SQL Queries on Excel Data
http://excellerando.blogspot.com/2014/09/from-time-to-time-it-necessary-to.html
Thursday, 18 September 2014. A Horrible Hack: Complex SQL Queries on Excel Data. A Cautionary Tale of things that no developer should ever see or do, with diversions and digressions into failures of business logic, workarounds and worse-arounds, budget fairies, business analysts, and scrofulous pilgrims seeking miraculous healing in the elevator lobby. Well, the answer to that is: "It's a prototype, and it's on the stack for the database developers to get it done properly". Except that it's still running...
TOTAL PAGES IN THIS WEBSITE
19
Hostnet: De grootste domeinnaam- en hostingprovider van Nederland.
Alles voor ondernemend Nederland. Wil jij ook zo'n unieke domeinnaam? Check of jouw domein nog vrij is:. Inbegrepen bij je domeinnaam. Stuur je mail door naar een ander e-mailadres. Maak eenvoudig je eigen miniwebsite. Verwijs je domeinnaam door naar een website. Hostnet registreerde met succes al meer dan 2 miljoen domeinnamen.
IIS7
IIS7
IIS7
IIS7
Excellerando
Friday, 3 July 2015. A Fishy Tale of Report Support. Not, strictly speaking, an Excel post at all: but I thought I'd share this with you anyway. From time to time, I have to cover the support work on a large reporting system which serves Excel files out through a web portal. We're running something between five hundred and a thousand distinct reports. Here's an edited - heavily redacted! Fish: "Hi, Aquarium Support Desk? Support: "Hello, this is the Aquarium Support Desk, can I help you? There's no 'punc...
Excellerando | Excel in Music
October 29, 2013. Welcome to WordPress. This is your first post. Edit or delete it, then start blogging! Proudly powered by WordPress.
excellerant.net - Crazy Domains
Search and register domain names. World's cheapest domain names. 700 New generic domains. Move your domains to us FREE. Express cheap domain renewal. Get the domain name you want. Everything you need for your domains. Control your CNAME, MX and A records. Find who owns a particular domain. COM only $9.00 Get yours! Join The Domain Club. Fast, reliable space for your website. Defend your site against hackers. Secure your site and data. Get your own me@mydomain.com. Automatic Spam and Virus protection.
Excellerant Partners Home
How does your company define Excellence? In today's rapidly changing global economy being great is just not good enough. Let's be realistic here. When your customers talk about your product and services how often is the word excellent used? Are you clearly differentiated from the competition? Is the word excellent apart of your values? Is it the defining attribute within your vision and mission statements? Are your employees rewarded, recognized and even incentivized for achieving levels of excellence?
excellerate-consulting.nl - Onjuiste verwijzing domein Byte b.v.
Het domein excellerate-consulting.nl verwijst naar een site bij Byte, maar komt niet voor in onze administratie. Indien je de beheerder van excellerate-consulting.nl bent en je wilt sites aan elkaar koppelen, dan kun je bij Byte een Presence-pakket bestellen. Zoek hier je domeinnaam:. Byte is een hostingprovider voor professionals en gespecialiseerd in:. Magento hosting met Hypernode technologie. WordPress hosting met clustertechnologie. Drupal hosting met clustertechnologie. Of neem contact met ons op.
