{"id":4270,"date":"2015-07-12T14:04:22","date_gmt":"2015-07-12T14:04:22","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/wp\/?p=4270"},"modified":"2017-08-29T17:54:51","modified_gmt":"2017-08-29T17:54:51","slug":"interacting-with-powerpoint-slides-tutorial-part-2","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/","title":{"rendered":"Complete VBA tutorial to interact with Power point Presentations – Part – 2 of 2"},"content":{"rendered":"

This is a continuation of my previous article<\/strong> <\/a> about Interaction with Power point Slides using Excel Macro. In my previous article we learn how to create a New Power Point Presentation using Excel Macro (by creating Power Point Object). <\/p>\n

Bit of a Story about this Article:<\/h1>\n

This article I planned to write due an incident took place at my work. Friday evening, clock is ticking to 5 PM..All set to go for the weekend… and then there was a request from my BOSS to do some copy paste work in bunch of Sales PPTs. There were around 20-30 PPTs, each of them having at least 5-6 Slides in it.
\nMy Job was to consolidate all the slides in one new Power Point Presentation. In a chat with my Boss, I realized that this activity is more frequently done by him. Then I put some effort and wrote an Excel Macro to do his Job faster without any manual error. At the end of this article you will find a downloadable, it’s the same version which I created.
\nLater after building this little tool for him, I realized that I can use this code to make quick presentations out of any dynamically generated reports\/data in excel and believe me it was very useful.
\nHowever this was a bit of story.. let’s get back to the topic…<\/p>\n

Topics covered in this Article<\/h1>\n

Click on the below links to directly jump to that section…<\/p>\n

\n
\n

<\/i>  What is the Power Point Application Object reference and How to add it<\/a><\/h2>\n

<\/i>  Excel VBA code to navigate to a specific slide in PPT<\/a><\/h2>\n

<\/i>  VBA Code to copy a slide from one Power Point to Another<\/a><\/h2>\n

<\/i>  Few VBA Trick while working with Slides<\/a><\/h2>\n<\/div>\n<\/div>\n

<\/a><\/p>\n

What is the Power Point Application Object reference and How to add it <\/h1>\n

The reference which you need to add in your Excel Code is Microsoft Power Point (12, 13, 14,15) Object Library<\/strong> as shown in the below picture.<\/p>\n

1. Open your VBE Code Screen (by Pressing ALT+F11)
\n2. From VBE screen go to Tools –> References
\n3. On Clicking on “References” you will see following screen, where you can look for the relevant reference and add it by selecting it.
\n\"Reference\"<\/p>\n

\nNow since, reference is already added, you don’t need to create an Object for Power Point using CreateObject<\/strong> keywords like it is done in my previous article.<\/p>\n

Now we can define a new variable of Power Presentation type <\/p>\n

\r\n        Dim newPowerPoint As PowerPoint.Application\r\n        Set newPowerPoint = New PowerPoint.Application\r\n<\/code><\/pre>\n
OR<\/h2>\n
\r\n        Dim newPowerPoint As New PowerPoint.Application\r\n<\/code><\/pre>\n
<\/a><\/p>\n
How to traverse all the slides of a Power Point Presentation<\/h1>\n
\r\n\r\nFunction get_Slide_Count()\r\n    Dim pPath As String\r\n    Dim pCount As Integer\r\n    Dim pPowerPoint As New PowerPoint.Application\r\n    Dim pPresentation As PowerPoint.Presentation\r\n    \r\n    'Full Path of your Power point presentation\r\n    pPath = "......\\PPT-Tutorial.pptx" 'For example\r\n    Set pPresentation = pPowerPoint.Presentations.Open(pPath)\r\n    \r\n    'Get the total count of slides\r\n    pCount = pPresentation.Slides.Count\r\n    \r\n    'Display message with total count\r\n    MsgBox "Total No# of Slides is: " & pCount\r\n\r\n    pPresentation.Close 'Close the power point presentation\r\n    pPowerPoint.Quit 'now quit the power point Application\r\n    \r\n    'Set both the Object variables to Nothing\r\n    Set pPresentation = Nothing\r\n    Set pPowerPoint = Nothing\r\nEnd Function\r\n<\/code><\/pre>\n
<\/a><\/p>\n
3. How to copy and Paste a slide from one Power Point to Another<\/h1>\n
In the below example, you also learn how to choose a particular slide from a bunch of slides in a single presentation.<\/p>\n
\r\nFunction CopyASlideFromOneToAnotherPPT()\r\n\r\n        Dim pPowerPoint As PowerPoint.Application\r\n        Set pPowerPoint = New PowerPoint.Application ' New powerpoint created\r\n        \r\n        Dim SourcePPT As PowerPoint.Presentation\r\n        Dim TargetPPT As PowerPoint.Presentation\r\n        pPowerPoint.Visible = msoTrue\r\n        'Full Path of your Power point presentation\r\n        SourcePPTPath = VBA.Environ("userprofile") & "\\desktop\\Parth-Presentation-sample.pptx" 'For example\r\n        TargetPPTPath = VBA.Environ("userprofile") & "\\desktop\\Parth-Presentation-sample2.pptx" 'For example\r\n        \r\n        Set SourcePPT = pPowerPoint.Presentations.Open(SourcePPTPath)\r\n        Set TargetPPT = pPowerPoint.Presentations.Open(TargetPPTPath)\r\n        \r\n        'Copy Slide#3 and paste it in Target Presentation as a Slide#4\r\n        SourcePPT.Slides(3).Copy 'copy the 3rd slide of the presentation\r\n        TargetPPT.Windows(1).Activate\r\n\t\t'it will paste as a 4th slide of the target presentation\r\n\t\t'If you do not pass any parameter then it always pastes the slide at the end\r\n        TargetPPT.Slides.Paste (4) \r\n        'save Target PPT\r\n        TargetPPT.Save\r\n        'Now close both the PPTs\r\n        SourcePPT.Close\r\n        TargetPPT.Close\r\n      \r\n        Set SourcePPT = Nothing\r\n        Set TargetPPT = Nothing\r\n        pPowerPoint.Quit 'close the powerpoint\r\n     \r\nEnd Function\r\n<\/code><\/pre>\n
<\/a><\/p>\n
Few helpful VBA Tricks related to Slides<\/h1>\n
From the above example, here are few more little variations which may help you:<\/p>\n
Trick to paste at the end of the presentation <\/h2>\n
TargetPPT.Slides.Paste<\/code><\/pre>\n
Trick to paste as a Second Last Slide of your presentation<\/h2>\n
TargetPPT.Slides.Paste (TargetPPT.Slides.Count - 1) <\/code><\/pre>\n
After a long read, here is your link to download it and Enjoy playing around the code !!! DO NOT forget to provide your feedback about anything you learn here in this forum \ud83d\ude42
\n <\/p>\n
\n\"Download<\/a>\n<\/div>\n<\/span>","protected":false},"excerpt":{"rendered":"
This is a continuation of my previous article about Interaction with Power point Slides using Excel Macro. In my previous article we learn how to create a New Power Point Presentation using Excel Macro (by creating Power Point Object). Bit of a Story about this Article: This article I planned to write due an incident […]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1246,1679,1675],"tags":[],"class_list":["post-4270","post","type-post","status-publish","format-standard","hentry","category-macro","category-excel-macro-beginner","category-excel-macro-for-beginners"],"yoast_head":"\nComplete VBA tutorial to interact with Power point Presentations - Part - 2<\/title>\n<meta name=\"description\" content=\"Complete VBA tutorial to interact with Powerpoint presentation. VBA to create presentations. VBA to add slides to a presentation. VBA code to delete slides\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Complete VBA tutorial to interact with Power point Presentations - Part - 2 of 2\" \/>\n<meta property=\"og:description\" content=\"Complete VBA tutorial to interact with Powerpoint presentation. VBA to create presentations. VBA to add slides to a presentation. VBA code to delete slides\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Let's excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2015-07-12T14:04:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-08-29T17:54:51+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/learnexcelmacro.com\/wp\/wp-content\/uploads\/sites\/11\/2015\/07\/Reference.png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Complete VBA tutorial to interact with Power point Presentations – Part – 2 of 2\",\"datePublished\":\"2015-07-12T14:04:22+00:00\",\"dateModified\":\"2017-08-29T17:54:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/\"},\"wordCount\":539,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2015\/07\/Reference.png\",\"articleSection\":[\"Excel Macro\",\"Excel Macro Beginner\",\"Excel Macro Tutorial\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/\",\"name\":\"Complete VBA tutorial to interact with Power point Presentations - Part - 2\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2015\/07\/Reference.png\",\"datePublished\":\"2015-07-12T14:04:22+00:00\",\"dateModified\":\"2017-08-29T17:54:51+00:00\",\"description\":\"Complete VBA tutorial to interact with Powerpoint presentation. VBA to create presentations. VBA to add slides to a presentation. VBA code to delete slides\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2015\/07\/Reference.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2015\/07\/Reference.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Macro\",\"item\":\"https:\/\/vmlogger.com\/excel\/macro\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Complete VBA tutorial to interact with Power point Presentations – Part – 2 of 2\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let's share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Complete VBA tutorial to interact with Power point Presentations - Part - 2","description":"Complete VBA tutorial to interact with Powerpoint presentation. VBA to create presentations. VBA to add slides to a presentation. VBA code to delete slides","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/","og_locale":"en_US","og_type":"article","og_title":"Complete VBA tutorial to interact with Power point Presentations - Part - 2 of 2","og_description":"Complete VBA tutorial to interact with Powerpoint presentation. VBA to create presentations. VBA to add slides to a presentation. VBA code to delete slides","og_url":"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2015-07-12T14:04:22+00:00","article_modified_time":"2017-08-29T17:54:51+00:00","og_image":[{"url":"http:\/\/learnexcelmacro.com\/wp\/wp-content\/uploads\/sites\/11\/2015\/07\/Reference.png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Complete VBA tutorial to interact with Power point Presentations – Part – 2 of 2","datePublished":"2015-07-12T14:04:22+00:00","dateModified":"2017-08-29T17:54:51+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/"},"wordCount":539,"commentCount":1,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2015\/07\/Reference.png","articleSection":["Excel Macro","Excel Macro Beginner","Excel Macro Tutorial"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/","url":"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/","name":"Complete VBA tutorial to interact with Power point Presentations - Part - 2","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2015\/07\/Reference.png","datePublished":"2015-07-12T14:04:22+00:00","dateModified":"2017-08-29T17:54:51+00:00","description":"Complete VBA tutorial to interact with Powerpoint presentation. VBA to create presentations. VBA to add slides to a presentation. VBA code to delete slides","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2015\/07\/Reference.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2015\/07\/Reference.png"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2015\/07\/interacting-with-powerpoint-slides-tutorial-part-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Macro","item":"https:\/\/vmlogger.com\/excel\/macro\/"},{"@type":"ListItem","position":3,"name":"Complete VBA tutorial to interact with Power point Presentations – Part – 2 of 2"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let's share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/4270"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=4270"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/4270\/revisions"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=4270"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=4270"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=4270"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}