Did I mention you're amazing?!


Yes, that's exactly what I'm looking for. However, I'm running into a snag. I changed the login to my own login to a spreadsheet to which I put the current version number (9.2) in field A1. I changed the macro to reference A1 in this line:

If CurrentVersion = oWB.Application.Range("$A$1") Then
And I also set 9.2 in this line:

CurrentVersion = "9.2"
So it should just do nothing right? But I still get the "you're not using the latest version" message. I also reference A1 in this line:

MsgBox ("Latest version is " & oWB.Application.Range("$A$1")) 'Proof that the Google spreadsheet has accessed successfully
And it DOES tell me 9.2 in that msgbox. What could be wrong here?