Learn Excel from MrExcel podcast, episode Getting a list of all the PDFs in a folder is a good starting point. I frequently want to run a VBA Macro on each file in a folder. While Power Query is amazingly powerful, this is one of my favorite tasks. Click the Refresh Icon in the Queries & Connections panel. The amazing part… you can refresh the query later.Right-Click the heading for the new column and Remove Other Columns.Choose Add Column, Merge Columns, Type a new Name for the Column.Drag Folder heading to the left of File heading.Keep only File Name and Folder – right-click each column heading and choose Remove.Open the filter on folder and remove any garbage subfolders.Open the filter dropdown on file type and remove anything that is not a PDF.The video below will show you the complete steps, but here is the overview: (Microsoft loves to change URLs every quarter and my awesome web guy hates when our links are out of date, so I am not even going to try to put a link here.) Go to your favorite search engine and type “Download Power Query” to find the current link. If you have Excel 2010 for Windows or Excel 2013 for Windows, you will have to download the free Power Query Add-in from Microsoft. This is easy to do if you are using Excel 2016 on a Windows PC using the new Get & Transform Data tools. Today’s question: Marcia needs to get a list of all of the tax invoice PDF files from a folder in to an Excel spreadsheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |