Information générale
Catégorie:
COM/DCOM et OLE Automation
Titre:
Excel automation problem
Hi
I have a problem creating a chart on a sheet in a workbook.
.ActiveChart.Location(xlLocationAsObject,"Summary Source")
should create the chart on the sheet titled "Summary Source". This is the second sheet of four.
But the chart is being created on the first sheet
I tried selecting the sheet with
.Sheets("Summary Source").Select
and in Excel that is showing as the selected sheet but the chart still goes on the first sheet.
Any ideas what I am doing wrong.
Thanks
Nick Mason
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement