I have just upgraded to Windows 7 running excel 2007.
Previously I was running XP, again with excel 2007.

The publishing Macro that worked with no problems on XP is now falling
over on Windows 7.

The error that I am getting is:
“Run-time error ‘1004’: The specified dimension is not valid for the
current chart type.”

When trying to execute the following VBA:

============================================
With ActiveWorkbook.PublishObjects.Add(xlSourceRange,
myfilename, mysheet, mypublish, xlHtmlStatic, mysheet, "")
.publish (True)
.AutoRepublish = False
End With
============================================

'mysheet' is a normal worksheet name
'mypublish' is a defined range name which contains one or more charts

Has anyone any idea wheat is going on or how I can fix it.