PDA

View Full Version : Copying to an Excel Chart Object



afx
06-05-2007, 04:53 AM
I'm trying to copy some information from a separate Excel file that I open separately.

The copying part is already done, but I can't seem to go back to the Powerpoint presentation, go to a specific slide, enter edit mode for an object (excel chart), change sheet in the object ("data") and paste in the first cell.

I know it must be really easy to do this but I can't seem to make it work...

Thanks in advance

afx
06-05-2007, 12:26 PM
I found a way to do it, it seems to work, but I can't test it just yet...
I'm having another problem because of the read-only settings on the files I have to access. I have to change the field from a pivottable to get another "set" of data.

wbExcel.ActiveSheet.PivotTables("PivotTable5").PivotFields("Model").CurrentPage = "xxx"
I'm getting this error "Unable to set the _Default property of the PivotItem class".
Is there a way I can work around this? I really need to find a way to make it work this way, maybe if there's a way to save a temporary copy locally and open this file... but I need to delete it afterwards.
This is really important and I need a solution really fast and I'm kinda tired of looking for a way to do it...