btabomb.blogg.se

I'm from the same era: Learned 123 in 1984/85 from a 5.25" floppy tutorial, & Multiplan, then progressed thru Symphony, Supercalc, back to 123, and then Excel 4 & 5 in 1995 - and have never looked back! That's the beauty and ugliness of Excel - there are more tools & features than you can ever learn or know about! Range(Selection, Selection.End(xlDown)).SelectĬells(lRow + 1, 1).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False

Range(Selection, Selection.End(xlToRight)).Select Workbooks(filename).Close SaveChanges:=False LRow = Cells(Rows.Count, 1).End(xlUp).RowĬells(lRow, 1).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False

Workbooks.Open filename:=folderPath & filename, ReadOnly:=FalseĪ(xlSrcRange, Selection,, xlYes).Name = "Table1"ĪctiveSheet.ListObjects("Table1").Range.AutoFilter Field:=7, Criteria1:="", Operator:=xlFilterValues " default location alias """ & RootFolder & """) as string" ScriptStr = "return posix path of (choose folder with prompt ""Select the folder""" & _ RootFolder = MacScript("return (path to desktop folder) as String") Im really at a loss on this one since it is just a loop doing the exact same thing that it did on the ones previous. But when I add any additional files to the same folder and run the marco all the data from the first 4 files is pulled but only 20 records from each of the remaining files are pulled. When I only have 4 files in the folder, all of the correct data is pulled as is should, minus issue 1 above. But the second file that is pulled the headers are grabbed, but that is the only other file where the headers are pulled.Ģ. With the first file the marco is set to pull the headers, but then on the second file and all subsequent files it isn't supposed to grab the headers. There are 2 issues that I am running into with the code.ġ. I am working on a macro that will allow me to select the folder these files are contained in and will then will loop through that folder and pull the necessary data out of the excel files and combine all of that into one master worksheet. I have many excel files, contained in a single folder, that all contain the same type of data in the same columns with varying amounts of rows in each.