a couple of laughzillas on a blue diamond background

Bing Pulse now lets anyone conduct audience polls

Dec04
by on December 4, 2014 at 6:59 am
Posted In: Apps, Around the Web

Bing Pulse
Microsoft said today that it is opening up its audience polling tool Bing Pulse to all users, to allow them to get reactions from groups at events and meetings in real-time, reports TechCrunch. Until now, the tool was only available through partnerships. Fox News used Bing Pulse to gauge how the nation felt during US President Obama’s State of the Union address last year in February. Bing Pulse lets users create a poll page using a simple Web-based interface and pose multiple questions on the page through the duration of their events, and automatically graph reactions over that period. You…

This story continues at The Next Web

└ Tags: ,
a couple of laughzillas on a blue diamond background

Evaluate Mid

Dec04
by on December 4, 2014 at 3:48 am
Posted In: Around the Web

In my last post, I created an array from formula text by using VBA’s Evaluate method, in order to roll my own FormulaArray function that displays the array returned by a formula, for documentation purposes.

In the course of this, I’ve discovered something a bit weird about how this method evaluates the arrays returned by a MID function.
Let’s use this snippet:

Sub EvaluateThis()
Dim var As Variant
var = ActiveSheet.Evaluate(ActiveCell.Formula)
End Sub

First, let’s look at how it handles an array generated by the COLUMN() function:
 
Evaluate COLUMN array2
 
 

Now watch what happens when we use that array to split apart a string using the MID() function:
 
Evaluate MID array2
 
 

So if you push F9, you get an array, but if you use the Evaluate method you don’t…you just get the first letter. Is this weird, or am I missing the point?

└ Tags: 
a couple of laughzillas on a blue diamond background

Apple removed songs from iPods without telling customers

Dec04
by on December 4, 2014 at 12:56 am
Posted In: Around the Web, Insider

1203_ipod
Music is incredibly personal. What we like says so much about us and acts as a roadmap of our lives with songs attached to moments. So when a company removes some of those songs from a device because they are from a rival, it’s kind of a big deal. The Wall Street Journal reports that between 2007 and 2009, Apple deleted music from users’ iPods that originated from competing digital music services. It didn’t just remove the music, instead it produced an error message that instructed users to restore their iPod when music from rival services was detected. Once the restore…

This story continues at The Next Web

└ Tags: , ,