Workbooks(name).Worksheets(1).Range('a4:t' & CellCount1).Copy Workbooks('temp1.xls').Worksheets(2).Range('a2')
Workbooks.Open Filename:=('C:\daily\out.xls')
Workbooks.Open Filename:=('C:\daily\' & name) I have around 2000 rows in a report each day and it would help me a lot to automatically remove those additional cells so 1 row would only include information about 1 entry. There are at least couple of rows like that in the report file and the rest is normal. LINE1 and LINE2 are two separate cells because ENTER was used in the description.Īnyone got a solution or a hint what a macro should look like when importing such a file? Mainly when I do the report the tables in HTML are shown properly however in couple of description fields there was the ENTER sign used and thus when importing into Excel it turns out to be a merged cell.Īnd so I receive a row of data in the format: I've prepared some nice macro's to import couple files at a time but and merge into one big report file however the report is not perfect and can't be sorted due to some merged cells. Next I can rename the file to report.xls which is not the best but quite efficient way to open the same table in Excel. I receive a report in a table but as a html web page(I select save as and them html). Basically I am currently responsible for extracting and creating reports from the system.
