ListObject.DisplayName = "Table003_Page_1_5_2"Īpplication.CommandBars("Queries and Connections"). "OLEDB Provider=.1 Data Source=$Workbook$ Location=""Table003 (-5) (2)"" Extended Properties=""""" _ QueryName = Replace(.Range("A1").Value, " ", "_")Ī Name:=queryName, Formula:= _ Click the Transform Data button to load the metadata into. From here, we see the metadata for each file in the selected folder. Navigate to the PDF folder’s location and click Open. Click Data (tab) -> Get & Transform (group) -> Get Data -> From File -> From Folder. ' queryName = Replace(.Range("A1").Value, " ", "_") We begin this adventure by starting Excel and creating a new, blank workbook. I found some code trying to modify the code in blue but getting stuckĭim queryName As String, sourceFullName As String I want to try to make it generic so that I can import any pdf.
the format of the pdf table is the same just the data changes. I am trying into import a pdf file into power query using vba.
0 kommentar(er)
