Archive for October, 2017

VBA course hosting

Friday, 27th October, 2017

I think I might have mentioned that I am thinking of making an online video VBA course?

Well anyway, I haven’t exactly finished the content yet…

But I have been poking around for a ‘platform’.

I was initially thinking of Udemy, and I still might go that way initially, but I have heard a few not so positive things about them from an instructor POV. Although I am not sure if that is all old stuff or recent.

Cost wise I imagine the course being around 50 quid/dollars/francs.

I had a look at this place and they have that price as an example.

If the student pays 50 quid the instructor can get as little as 3.15!!!!!

That is the content creator, the author, gets just over 5% of the price the student pays!!

I just can’t quite believe it!

I think I might look into creating a ‘platform’ instead. Its only hosting with a few bells and whistles, most of which I won’t use.

Maybe I’ll have to do youtube with ads after all.

Some Blog stats

Saturday, 7th October, 2017

Here are the top 10 or so pages on this blog over the last 10 years. Not perfect as some of these have probably been here for 10 years, some might be merely months old.

But still the focus on 2007 errors makes me laugh. Maybe I didn’t post much about 2010 errors (2003, as we know didn’t have any (ha ha)).

In fairness 2010 was much better than 2007 in almost every way. Well, except dev tools maybe (the bit we looked at ironically).

Home page / Archives 171,829
Excel 2007 workbook window not visible 75,716
Excel 2007 Error: Link source not found 15,901
R1C1 notation 13,728
The spreadsheet disadvantage 12,988
Excel 2007 screen lock up 10,373
Code execution has been interrupted 10,280
Excel 2007 =#N/A error 9,550
xlls With ExcelDNA 7,530
Excel 2007 screen / video issues 6,290

Delighted to see ExcelDNA in there too, it is an excellent tool.

And lo, what’s that? a spreadsheet quality post in the mix? Methinks a far sighted undergrad course may have pointed the students towards some research into the disadvantages of using spreadsheets (for everything).

I never started SOS to get big viewer numbers, I wanted to have a conversation about more advanced Excel development related topics. Somewhere where XLM would not be auto ‘corrected’ to XML, somewhere we could discuss the merits of the C API v the COM interface, or the merits of manual calc v auto calc without drowning in ‘my Excel stopped adding up’ cries.

I have always resisted going for the bulk beginner audience here. But I am contemplating developing a beginner level VBA course at the moment, so may have to revisit that. Although I would probs set up yet another blog I think.

So anyway there you go, at least 75,000 people came here because they could not find their Excel 2007 workbook window.