Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
open & repair through vba
Is there any way that I can utilize Open and Repair facility through
VBA code? I need to run that by skipping all the messages and straight away extracting the data & converting the values. Regards, Bayo |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
open & repair through vba
Bayo
I've had the same problem today, searched for a solution, didn't find one, but saw yours! Luckily I've worked out the answer. You need to enable the CorruptLoad, that is Workbooks.Open(Fname, , , , , , , , , , , , , , True) (Where Fname is the filename you wish to open. This will then open the file without the macro falling over, you can then extract the data and to what you want. Hope this helps, and it isn't too late " wrote: Is there any way that I can utilize Open and Repair facility through VBA code? I need to run that by skipping all the messages and straight away extracting the data & converting the values. Regards, Bayo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unknown repair | Excel Discussion (Misc queries) | |||
Open & repair didn't fix my excel file?! | Excel Discussion (Misc queries) | |||
Excel does not open a file until it is minimized - how to repair? | Excel Discussion (Misc queries) | |||
Looking For a repair tool | Excel Discussion (Misc queries) | |||
corrupt document and open and repair command | Excel Discussion (Misc queries) |