My task is select a particular value of field, select a particular chart and paste it in a presentation. everything works fine, except my sheet does not get refreshed for a selected value of a field.
to me looks like probelm is in the highlighted row (bold and underlined).
I am getting same chart on all slides.
sub change_filter
ActiveDocument.Sheets("SH05").Activate
ActiveDocument.GetApplication.WaitForIdle
'Settings
set obj = ActiveDocument.GetSheetObject("CH23")
'Set object width and height
set fr = obj.GetFrameDef
set pos = fr.Rect
pos.Width = pos.width * 1.2
pos.Height = pos.Height * 1.6
obj.SetFrame fr,true,""
ActiveDocument.ActiveSheet.FitZoomToWindow
ActiveDocument.ActiveSheet.ApplyZoomToAllSheets
Set PPApp = CreateObject("PowerPoint.Application")