J
Jon
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.
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.