Dear Friends,
Please help me for Repairing the Excel Corrupted file.
I used "Advanced Office Repair - Version 1.0" for Repairing file but result is not Good Only Value are back & the text are missing.
Corrupted file are attached
Dear Friends,
Please help me for Repairing the Excel Corrupted file.
I used "Advanced Office Repair - Version 1.0" for Repairing file but result is not Good Only Value are back & the text are missing.
Corrupted file are attached
I tried to get the data from your corrupted file by writing the below VBA code and I ended up with the attached result
In the above code change this D:\Another New Temp\new to your file path![]()
Sub GetDataFromCorruptedWorkbook() Dim Ws As Worksheet Application.ScreenUpdating = False With GetObject("D:\Another New Temp\new\Contractor Diesel Statment.xls") For Each Ws In .Sheets ThisWorkbook.Sheets.Add Sheets(Sheets.Count) ActiveSheet.Name = Ws.Name Ws.Cells.Copy ActiveSheet.Range("A1") Next Ws .Close End With Application.ScreenUpdating = True End Sub
![]()
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
My Problem is not solved yet .....
Please help me
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks