amartakale
03-27-2019, 09:47 PM
Dear All,
Can we excel picture object chart paste in specific ppt as per slide name/number through VBA code.
Actually I have one excel sheet include VBA macro recording. There are more than 20 sheet with prepare chart & table which auto update after refresh on Bloomberg desk on daily basis.
If I Press Ctrl+Shift+M then all chart paste in first sheet (Name: Paste) as a paste special picture object &
If I Press Ctrl+Shift+N then all remaining chart paste in second sheet (Name: Paste1) as a paste special picture object.
After update Sheet I manually all chart paste in my specific PPT one by one (Total 20 chart & table).But After paste I manage chart & table size & adjusted as per fit in PPT nearby text matter. some slide paste only one chart, some slide paste two chart ,so on.then save & send. But it is time consuming.
I required such VBA code in excel where I click one button then all picture object (Picture 1, Picture 2, Picture 3, so on….) of first & second sheet in my workbook & paste in my specific PPT as per slide name or slide number & also adjusted chart & table size (if place will fix for every chart & table then it is very amazing for me) which I fixed for it.
Can we made this type of VBA code?
Thanks & Regards
Amar
Can we excel picture object chart paste in specific ppt as per slide name/number through VBA code.
Actually I have one excel sheet include VBA macro recording. There are more than 20 sheet with prepare chart & table which auto update after refresh on Bloomberg desk on daily basis.
If I Press Ctrl+Shift+M then all chart paste in first sheet (Name: Paste) as a paste special picture object &
If I Press Ctrl+Shift+N then all remaining chart paste in second sheet (Name: Paste1) as a paste special picture object.
After update Sheet I manually all chart paste in my specific PPT one by one (Total 20 chart & table).But After paste I manage chart & table size & adjusted as per fit in PPT nearby text matter. some slide paste only one chart, some slide paste two chart ,so on.then save & send. But it is time consuming.
I required such VBA code in excel where I click one button then all picture object (Picture 1, Picture 2, Picture 3, so on….) of first & second sheet in my workbook & paste in my specific PPT as per slide name or slide number & also adjusted chart & table size (if place will fix for every chart & table then it is very amazing for me) which I fixed for it.
Can we made this type of VBA code?
Thanks & Regards
Amar