Office Genuine Advantage team told me to post here

[Guest Andy]

Hi,

 

I have an activated Office 2007 Ultimate which seems fine in every way

EXCEPT when I try to pull down an Excel 2003 "MSN Stock Quote" macro

(http://www.microsoft.com/downloads/details.aspx?FamilyID=485FCCD8-9305-4535-B939-3BF0A740A9B1&displaylang=en)

which fails re-validation of Office 2007 with "Microsoft Office Ultimate

2007: Product Not Activated." I was instructed by "Lori MS" in the Office

Genuine Advantage forum to delete the file C:\Documents and Settings\All

Users\Application Data\Microsoft\Office\Data\data.dat to cause it to

re-activate. I didn't have a data.dat file in that directory but did have an

opa12.dat which I renamed and it seemed to have desired effect of asking me

to re-activate Office next time I fired up MS Word. And that re-activation

went fine. HOWEVER, when I try to retrieve the macro from MS site, same

problem. Still says "Microsoft Office Ultimate 2007: Product Not Activated."

 

"Lori MS" advised if I still had Genuine Advantage problems, to post them

here (and not in the "Office Genuine Advantage Validation Issues" group I

originally posted to). I still have a problem in that MS Excel Macro Web

site still refuses to validate my Office 2007 Ultimate installation properly

(perhaps that Web site itself is broken in the way it verifies Office 2007

activation??). For more details on my configuration, please see the original

string at

http://forums.microsoft.com/genuine/showpost.aspx?postid=3588680&siteid=25.

 

Thanks for any help with ongoing Office 2007 validation (detection) issues!

Seems like validation bugs should not get in the way of getting value out of

Microsoft products.

 

-Andy

[Guest Carey Frisch [MVP]]

Re: Office Genuine Advantage team told me to post here

 

That file "Excel 2003/2002 Add-in: MSN Money Stock Quotes"

is not supported in Office 2007. Read the system requirements.

 

--

Carey Frisch

Microsoft MVP

Windows Desktop Experience -

Windows Vista Enthusiast

 

---------------------------------------------------------------

 

"Andy" <Andy@discussions.microsoft.com> wrote in message news:36A03D6D-0C79-46D9-9846-E1E88F274040@microsoft.com...

Hi,

 

I have an activated Office 2007 Ultimate which seems fine in every way

EXCEPT when I try to pull down an Excel 2003 "MSN Stock Quote" macro

(http://www.microsoft.com/downloads/details.aspx?FamilyID=485FCCD8-9305-4535-B939-3BF0A740A9B1&displaylang=en)

which fails re-validation of Office 2007 with "Microsoft Office Ultimate

2007: Product Not Activated." I was instructed by "Lori MS" in the Office

Genuine Advantage forum to delete the file C:\Documents and Settings\All

Users\Application Data\Microsoft\Office\Data\data.dat to cause it to

re-activate. I didn't have a data.dat file in that directory but did have an

opa12.dat which I renamed and it seemed to have desired effect of asking me

to re-activate Office next time I fired up MS Word. And that re-activation

went fine. HOWEVER, when I try to retrieve the macro from MS site, same

problem. Still says "Microsoft Office Ultimate 2007: Product Not Activated."

 

"Lori MS" advised if I still had Genuine Advantage problems, to post them

here (and not in the "Office Genuine Advantage Validation Issues" group I

originally posted to). I still have a problem in that MS Excel Macro Web

site still refuses to validate my Office 2007 Ultimate installation properly

(perhaps that Web site itself is broken in the way it verifies Office 2007

activation??). For more details on my configuration, please see the original

string at

http://forums.microsoft.com/genuine/showpost.aspx?postid=3588680&siteid=25.

 

Thanks for any help with ongoing Office 2007 validation (detection) issues!

Seems like validation bugs should not get in the way of getting value out of

Microsoft products.

 

-Andy

[Guest Peter Foldes]

Re: Office Genuine Advantage team told me to post here

 

Andy

 

Unfortunately you were told wrong. This group is for the XP Operating System and hour's is a issue with Office and as such should be posted there. Below is the link where you should post this. Good Luck

 

On the Web

http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.office.setup

 

On your newsreader

 

http://news://msnews.microsoft.com/micrisift.public.office.setup

 

--

Peter

 

Please Reply to Newsgroup for the benefit of others

Requests for assistance by email can not and will not be acknowledged.

 

"Andy" <Andy@discussions.microsoft.com> wrote in message news:36A03D6D-0C79-46D9-9846-E1E88F274040@microsoft.com...

> Hi,

>

> I have an activated Office 2007 Ultimate which seems fine in every way

> EXCEPT when I try to pull down an Excel 2003 "MSN Stock Quote" macro

> (http://www.microsoft.com/downloads/details.aspx?FamilyID=485FCCD8-9305-4535-B939-3BF0A740A9B1&displaylang=en)

> which fails re-validation of Office 2007 with "Microsoft Office Ultimate

> 2007: Product Not Activated." I was instructed by "Lori MS" in the Office

> Genuine Advantage forum to delete the file C:\Documents and Settings\All

> Users\Application Data\Microsoft\Office\Data\data.dat to cause it to

> re-activate. I didn't have a data.dat file in that directory but did have an

> opa12.dat which I renamed and it seemed to have desired effect of asking me

> to re-activate Office next time I fired up MS Word. And that re-activation

> went fine. HOWEVER, when I try to retrieve the macro from MS site, same

> problem. Still says "Microsoft Office Ultimate 2007: Product Not Activated."

>

> "Lori MS" advised if I still had Genuine Advantage problems, to post them

> here (and not in the "Office Genuine Advantage Validation Issues" group I

> originally posted to). I still have a problem in that MS Excel Macro Web

> site still refuses to validate my Office 2007 Ultimate installation properly

> (perhaps that Web site itself is broken in the way it verifies Office 2007

> activation??). For more details on my configuration, please see the original

> string at

> http://forums.microsoft.com/genuine/showpost.aspx?postid=3588680&siteid=25.

>

> Thanks for any help with ongoing Office 2007 validation (detection) issues!

> Seems like validation bugs should not get in the way of getting value out of

> Microsoft products.

>

> -Andy

>

[Guest Andy]

Re: Office Genuine Advantage team told me to post here

 

Thanks for the pointer, Carey. I found the Microsoft MSN stock quote macro

here

 

http://www.vertex42.com/ExcelTemplates/excel-stock-quotes.html

 

and they're very explicit about the macro working with Excel 2007. But I do

take your point about the listed supported versions of Excel on the MS Web

page itself not including Excel 2007. I'm still confused why the MS Web page

validation step would say "Microsoft Office Ultimate 2007: Product Not

Activated" (which is incorrect) instead of saying something like "This macro

does not support Excel 2007". That's a bug.

 

I've given up trying to get the MSN stock quote macro from Microsoft to work

with my Excel 2007. I wrote my own which takes the selected cell and

retrieves and places the current stock/fund quote in the cell to immediate

right. It is below in case anyone else can use it.

 

-Andy

 

 

 

 

 

 

Sub GetStock()

Dim s As String

Dim ret As Double

Dim tempSheet As Worksheet

s = Selection.Value

Set tempSheet = ActiveWorkbook.Worksheets.Add

tempSheet.Visible = xlSheetHidden

With tempSheet.QueryTables.Add(Connection:= _

"URL;http://finance.yahoo.com/q/cq?s=" & s,

Destination:=tempSheet.Range("$A$1"))

.Name = "cq?s=msft"

.FieldNames = True

.RowNumbers = False

.FillAdjacentFormulas = False

.PreserveFormatting = True

.RefreshOnFileOpen = False

.BackgroundQuery = True

.RefreshStyle = xlInsertDeleteCells

.SavePassword = False

.SaveData = True

.AdjustColumnWidth = True

.RefreshPeriod = 0

.WebSelectionType = xlSpecifiedTables

.WebFormatting = xlWebFormattingNone

.WebTables = "11"

.WebPreFormattedTextToColumns = True

.WebConsecutiveDelimitersAsOne = True

.WebSingleBlockTextImport = False

.WebDisableDateRecognition = False

.WebDisableRedirections = False

.Refresh BackgroundQuery:=False

End With

ret = tempSheet.Range("C2").Value

Application.DisplayAlerts = False

tempSheet.Delete

Application.DisplayAlerts = True

ActiveCell.Offset(0, 1).Value = ret

End Sub

 

 

 

 

 

 

"Carey Frisch [MVP]" wrote:

> That file "Excel 2003/2002 Add-in: MSN Money Stock Quotes"

> is not supported in Office 2007. Read the system requirements.

>

> --

> Carey Frisch

> Microsoft MVP

> Windows Desktop Experience -

> Windows Vista Enthusiast

>

> ---------------------------------------------------------------

>

> "Andy" <Andy@discussions.microsoft.com> wrote in message news:36A03D6D-0C79-46D9-9846-E1E88F274040@microsoft.com...

> Hi,

>

> I have an activated Office 2007 Ultimate which seems fine in every way

> EXCEPT when I try to pull down an Excel 2003 "MSN Stock Quote" macro

> (http://www.microsoft.com/downloads/details.aspx?FamilyID=485FCCD8-9305-4535-B939-3BF0A740A9B1&displaylang=en)

> which fails re-validation of Office 2007 with "Microsoft Office Ultimate

> 2007: Product Not Activated." I was instructed by "Lori MS" in the Office

> Genuine Advantage forum to delete the file C:\Documents and Settings\All

> Users\Application Data\Microsoft\Office\Data\data.dat to cause it to

> re-activate. I didn't have a data.dat file in that directory but did have an

> opa12.dat which I renamed and it seemed to have desired effect of asking me

> to re-activate Office next time I fired up MS Word. And that re-activation

> went fine. HOWEVER, when I try to retrieve the macro from MS site, same

> problem. Still says "Microsoft Office Ultimate 2007: Product Not Activated."

>

> "Lori MS" advised if I still had Genuine Advantage problems, to post them

> here (and not in the "Office Genuine Advantage Validation Issues" group I

> originally posted to). I still have a problem in that MS Excel Macro Web

> site still refuses to validate my Office 2007 Ultimate installation properly

> (perhaps that Web site itself is broken in the way it verifies Office 2007

> activation??). For more details on my configuration, please see the original

> string at

> http://forums.microsoft.com/genuine/showpost.aspx?postid=3588680&siteid=25.

>

> Thanks for any help with ongoing Office 2007 validation (detection) issues!

> Seems like validation bugs should not get in the way of getting value out of

> Microsoft products.

>

> -Andy

>

>