{"id":12085,"date":"2011-11-13T19:30:57","date_gmt":"2011-11-13T19:30:57","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=571"},"modified":"2022-08-17T19:21:24","modified_gmt":"2022-08-17T19:21:24","slug":"how-to-get-list-of-all-files-in-a-folder-and-sub-folders","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/","title":{"rendered":"List All files from Folder and Sub-folders in Excel Workbook"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.17.6″ custom_padding=”0px|0px|0px|0px|true|true” da_disable_devices=”off|off|off” global_colors_info=”{}” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on”][et_pb_row admin_label=”row” _builder_version=”4.17.6″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”0px|0px|0px|0px|true|true” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.17.6″ _module_preset=”default” custom_padding=”0px|0px|0px|0px|false|false” global_colors_info=”{}”]In this article, we are going to learn about how to list the files from folders<\/span>. Here we will also learn how to list files from subfolders<\/span> as well. By using File System Object<\/span>, we can get the list of all Files inside a folder. An important thing to note here is that File System Object can list only files inside a folder. That means, there can be two scenarios here:
\nScenario 1: <\/span> User wants to list all files from the parent folder only. In this case, all the sub-folders inside the parent folder will be ignored.
\nScenario 2: <\/span> User wants to list of all files in parent folder and their sub-folders.
\nLet’s take a look in both the scenarios one by one.<\/p>\n

User wants to get the list of All files inside a folder<\/a>
\n
User wants to get the list of all files inside a folder as well as Sub-folders<\/a>
\n
Free Download – File Manager in Excel<\/a><\/p>\n

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

i) VBA code to List all files within a Folder Only<\/h1>\n

Copy and Paste the below Code and this will list down the list of all the files inside the folder. This will list down all the files only in the specified folder. If there are other files that are there in some other Sub-folders.<\/p>\n

\n\nSub GetFilesInFolder(SourceFolderName As String)\n\n'--- For Example:Folder Name= "D:\\Folder Name\\"\n\nDim FSO As Scripting.FileSystemObject\nDim SourceFolder As Scripting.folder, SubFolder As Scripting.folder\nDim FileItem As Scripting.File\n\n    Set FSO = New Scripting.FileSystemObject\n    Set SourceFolder = FSO.GetFolder(SourceFolderName)\n\n    '--- This is for displaying, wherever you want can be configured\n\n    r = 14\n    For Each FileItem In SourceFolder.Files\n        Cells(r, 2).Formula = r - 13\n        Cells(r, 3).Formula = FileItem.Name\n        Cells(r, 4).Formula = FileItem.Path\n        Cells(r, 5).Formula = FileItem.Size\n        Cells(r, 6).Formula = FileItem.Type\n        Cells(r, 7).Formula = FileItem.DateLastModified\n        Cells(r, 8).Formula = "=HYPERLINK(""" &amp; FileItem.Path &amp; """,""" &amp; "Click Here to Open" &amp; """)"\n\n        r = r + 1   ' next row number\n    Next FileItem\n\n    Set FileItem = Nothing\n    Set SourceFolder = Nothing\n    Set FSO = Nothing\nEnd Sub\n\n<\/code><\/pre>\n

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

ii) VBA code to List all files within a Folder and sub-folders as well<\/h1>\n

Copy and Paste the below Code and this will list down the list of all the files inside the folder as well as sub-folders. If there are other files that are there in some other Sub-folders then it will list down all files from each and Every Folder and Sub-folders.<\/p>\n

\nSub GetFilesInFolder(SourceFolderName As String, Subfolders As Boolean)\n\n'--- For Example:Folder Name= "D:\\Folder Name\\" and Flag as Yes or No\n\nDim FSO As Scripting.FileSystemObject\nDim SourceFolder As Scripting.folder, SubFolder As Scripting.folder\nDim FileItem As Scripting.File\n'Dim r As Long\n    Set FSO = New Scripting.FileSystemObject\n    Set SourceFolder = FSO.GetFolder(SourceFolderName)\n\n    '--- This is for displaying, wherever you want can be configured\n\n    r = 14\n    For Each FileItem In SourceFolder.Files\n        Cells(r, 2).Formula = r - 13\n        Cells(r, 3).Formula = FileItem.Name\n        Cells(r, 4).Formula = FileItem.Path\n        Cells(r, 5).Formula = FileItem.Size\n        Cells(r, 6).Formula = FileItem.Type\n        Cells(r, 7).Formula = FileItem.DateLastModified\n        Cells(r, 8).Formula = "=HYPERLINK(""" &amp; FileItem.Path &amp; """,""" &amp; "Click Here to Open" &amp; """)"\n\n        r = r + 1   ' next row number\n    Next FileItem\n\n    '--- This is the Function to go each and Every Folder and get the Files. This is a Nested-Function Calling.\n\n    If Subfolders = True Then\n        For Each SubFolder In SourceFolder.Subfolders\n            ListFilesInFolder SubFolder.Path, True\n        Next SubFolder\n    End If\n\n    Set FileItem = Nothing\n    Set SourceFolder = Nothing\n    Set FSO = Nothing\nEnd Sub\n<\/code><\/pre>\n

<\/a>[\/et_pb_text][et_pb_blurb title=”You may want to read these articles too” use_icon=”on” font_icon=”||fa||900″ _builder_version=”4.17.6″ _module_preset=”0249c68e-4de8-4f44-84ff-a9b1850785b6″ hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n

    \n
  1. List all Folders and Sub-folders in Hierarchical Structure [FREE DOWNLOAD FILE]<\/a><\/li>\n
  2. Download Free File Manager – New Version<\/a><\/li>\n
  3. Download Free File Manager in Excel Macro<\/a><\/li>\n
  4. How to create folders in windows via Excel VBA<\/a><\/li>\n
  5. Download Free Add-in – File Manager<\/a><\/li>\n<\/ol>\n

    [\/et_pb_blurb][et_pb_cta title=”File Manager using Excel Macro in Excel Workbook” button_url=”\/excel\/wp-content\/downloads\/File_Manager.xlsm” button_text=”Download File Manager” _builder_version=”4.17.6″ _module_preset=”a50a16dd-d05f-4ea2-acab-1468d2e4010e” global_colors_info=”{}”]I have created one File Manager using the above Code. It basically fetches the list of Files from Folders and Sub-folders and lists them. It fetches other details of the files as well like File Size, Last modified, the path of the File, Type of the File, and a hyperlink to open the file directly from excel by clicking on that.
    \nIt looks something like the below:<\/p>\n

    \"Excel<\/a>

    File Manager in Excel Workbook<\/p><\/div>[\/et_pb_cta][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n<\/span>","protected":false},"excerpt":{"rendered":"

    In this article, we are going to learn about how to list the files from folders. Here we will also learn how to list files from subfolders as well. By using File System Object, we can get the list of all Files inside a folder. An important thing to note here is that File System […]<\/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":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1246,1682],"tags":[],"class_list":["post-12085","post","type-post","status-publish","format-standard","hentry","category-macro","category-popular-articles"],"yoast_head":"\nMacro to List files from Folder and Sub-folders in Excel Workbook<\/title>\n<meta name=\"description\" content=\"[FREE DOWNLOAD] File Manager. VBA to List files from all folders and sub-folders. Macro to list files from directories in your Excel.\" \/>\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\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"List All files from Folder and Sub-folders in Excel Workbook\" \/>\n<meta property=\"og:description\" content=\"[FREE DOWNLOAD] File Manager. VBA to List files from all folders and sub-folders. Macro to list files from directories in your Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/\" \/>\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=\"2011-11-13T19:30:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-17T19:21:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/File_Manager.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\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"List All files from Folder and Sub-folders in Excel Workbook\",\"datePublished\":\"2011-11-13T19:30:57+00:00\",\"dateModified\":\"2022-08-17T19:21:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/\"},\"wordCount\":629,\"commentCount\":173,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/File_Manager.png\",\"articleSection\":[\"Excel Macro\",\"Popular Articles\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/\",\"name\":\"Macro to List files from Folder and Sub-folders in Excel Workbook\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/File_Manager.png\",\"datePublished\":\"2011-11-13T19:30:57+00:00\",\"dateModified\":\"2022-08-17T19:21:24+00:00\",\"description\":\"[FREE DOWNLOAD] File Manager. VBA to List files from all folders and sub-folders. Macro to list files from directories in your Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/File_Manager.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/File_Manager.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/#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\":\"List All files from Folder and Sub-folders in Excel Workbook\"}]},{\"@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":"Macro to List files from Folder and Sub-folders in Excel Workbook","description":"[FREE DOWNLOAD] File Manager. VBA to List files from all folders and sub-folders. Macro to list files from directories in your Excel.","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\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/","og_locale":"en_US","og_type":"article","og_title":"List All files from Folder and Sub-folders in Excel Workbook","og_description":"[FREE DOWNLOAD] File Manager. VBA to List files from all folders and sub-folders. Macro to list files from directories in your Excel.","og_url":"https:\/\/vmlogger.com\/excel\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/","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":"2011-11-13T19:30:57+00:00","article_modified_time":"2022-08-17T19:21:24+00:00","og_image":[{"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/File_Manager.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\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"List All files from Folder and Sub-folders in Excel Workbook","datePublished":"2011-11-13T19:30:57+00:00","dateModified":"2022-08-17T19:21:24+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/"},"wordCount":629,"commentCount":173,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/File_Manager.png","articleSection":["Excel Macro","Popular Articles"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/","url":"https:\/\/vmlogger.com\/excel\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/","name":"Macro to List files from Folder and Sub-folders in Excel Workbook","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/File_Manager.png","datePublished":"2011-11-13T19:30:57+00:00","dateModified":"2022-08-17T19:21:24+00:00","description":"[FREE DOWNLOAD] File Manager. VBA to List files from all folders and sub-folders. Macro to list files from directories in your Excel.","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/File_Manager.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/File_Manager.png"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/how-to-get-list-of-all-files-in-a-folder-and-sub-folders\/#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":"List All files from Folder and Sub-folders in Excel Workbook"}]},{"@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\/12085"}],"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=12085"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12085\/revisions"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12085"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12085"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12085"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}