lundi 13 avril 2015

How to "Reset Picture" in Power point Slide using VBA macro?

I am generating power point presentation using Excel. The macro is running excel. It is working perfectly fine. Issues is the Excel macro pasted the pictures with strange format. I have to use manually the command of "Reset Picture" by right clicking on each picture-->Picture format--> Reset picture


Is it possible to make a macro power point which can do the reset picture command automatically for me?


THanking you advance Best regards



'getting name of picture from Excel sheet cell

logopic = ThisWorkbook.Sheets("Jan 2015").Range("z" & CellNr).Value
apic = ThisWorkbook.Sheets("Jan 2015").Range("aa" & CellNr).Value
mpic = ThisWorkbook.Sheets("Jan 2015").Range("ab" & CellNr).Value


If ThisWorkbook.Sheets("Jan 2015").Range("z" & CellNr) > 0 Then


' here we are copying the pictures of logo in the respective slides



oPP1.Slides(2).Shapes.AddPicture("" & FolderPath & "\" & logopic & ".jpg", msoFalse, msoCTrue, 10, 10, 60, 45).Apply

Aucun commentaire:

Enregistrer un commentaire