Macro errors when upgrading to windows 7

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top