Consolidating data in excel 2016

Value End If Next s Extract_File_Name = "Budget_Extract_File.txt" If Len(Dir(s Path Name & "\Temp", vb Directory)) = 0 Then Mk Dir s Path Name & "\Temp" End If s Extract_Full_Name = s Path Name & "\Temp\" & s Extract_File_Name Open s Extract_Full_Name For Output As #2 my File = Dir(s Path Name & "\*.xlsm") 'The macro checks for budget files that are saved with the extension. Clear 'Loop through each budget file to Extract Budget data onto Extract File Do While my File "" Set wb2 = Workbooks.

Value If Key "" Then 'Do Nothing Else Exit For End If If Exchange_Rates.exists(Key) Then 'Do Nothing Else Exchange_Rates. The budget preparation directions should also mention this to avoid rework. Find("*", Search Order:=xl By Rows, Search Direction:=xl Previous).

Thus, all files _ should be saved with this format, not .xlsm, etc. Open(File Name:=s Path Name & "\" & my File, Update Links:=False, Read Only:=True) 'Op For Row = 1 To Num Rows Application.

Whenever the code is run, after the files have been process, we reeive a Run Time Error '7' Out of Memory error. Screen Updating = False 'Turns off screen updating; for example, when the macro opens a budget file, you will just see a _ blank screen.

I believe this is because the text file is not being populated with any data for some reason, although I am open to any other suggestions.

I have included the code below and have highlighted the area where the error occurs. Dim fldr As File Dialog 'Placeholder for the selected folder by the user Dim str Full Path As String Dim Categories As Variant Dim Exchange_Rate As Long Dim k As Integer Dim s Time As String Dim Config_Last Row, Source_Last Row As Integer Dim Last Col, Last Row As Integer Dim fso As Object Dim s Path Name As String Dim Key As String Dim c, q As Integer Dim Consolidate_Row As Integer Dim Out_Of_Policy_Flag_Col As Integer Out_Of_Policy_Flag_Col = 33 Set fso = Create Object("Scripting.

File System Object") Set Exchange_Rates = Create Object("Scripting.

Find("*", Search Order:=xl By Rows, Search Direction:=xl Previous). Find("*", Search Order:=xl By Rows, Search Direction:=xl Previous).

Delete Shift:=xl Up End If For Each ws In Active Workbook.

There might be some different worksheets (or workbooks) that you have in your collection with data arranged differently, but you’ll still want to create a pivot table.

Tags: , ,