Excel 2007 and XML macros

[reinstalled]

Hi,

I just upgraded a user to office 07 and excel hangs on two lines in an old XML macro now. Looking for a bit of insight as I have tries everything I can think of and have all but learned an old, outdated macro language.

Hanging on the UNHIDE line and I'm not sure if it's the UNHIDE or the GET.WINDOW. The get.window seems to be passing the correct name(added ALERT statement).
UNHIDE is trying to bring up the chrat created in CREATE.Object

=CREATE.OBJECT(5,"R19C27",10,,"R35C36",,,1,TRUE)
=CHART.WIZARD(TRUE,"R1C23:R1441C23,R1C25:R1441C25",3,3,2,1,1,2,"","","","")
=UNHIDE(GET.WINDOW(1)&" "&DiskChartName)

Thanks!

 

[GlennUK]

I don't that there's anything wrong with the code. I think that Chart objects behave differently in Excel 2007. ( I don't have 2007, so can't experiment for you ).


I've just had a look in my old macro function help ( help for XLM commands ... have a look here:

http://support.microsoft.com/kb/128185

... it may help )... and the UNHIDE command is used to activate an embedded chart object:

Tip You can use UNHIDE to activate an embedded chart in order to edit and format it. Use the HIDE function to de-activate the chart window.

I don't think that Excel 2007 embedded charts operate the same way.

Have you thought about converting the macro to VBA?

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[kjv1611]

chrat

There's yer problem!

--

"If to err is human, then I must be some kind of human!" -Me

 

[SkipVought]

kvj, I haev that problme all the tiem.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}