help needed Copying data values from closed workbook

Hi Excel Professionals,

There is a simple, problem, my file in C:\Test\Report1.xlsx a bit broken,could not open it (not encrypted), That's i need to copy Data from it without opening it cells are A1:C100

Could you be kind to give a hand to get out of this situation?

Thank You,
Akmal

I tried several recovery options, recommended by microsoft and other web-sites all of them did no effect, and i am writing here in order to find Answer to my questions, in my opinion VBA is the last option...

I'll try to help you but....what happens when you try to open it? If your file is badly corrupted it may be impossible to read it without opening it. I know you've tried a lot of things but if you attach the file someone here may have additional insight as to how to restore your file.

Here is general-purpose code that will read data from a file without opening it. It uses an approach that was developed for databases but will work with Excel files. It will only retrieve the data, not any formatting. Originally sourced from Ron de Bruin.

To Call:

SourceFile: Full path name of the Excel file you want to read
SourceSheet: Sheet name (as seen on tab) of the sheet you want to read
SourceRange: A string giving the range you want to read.
TargetRange: A Range object that says where you want to write the data that you read
Header, UseHeaderRow: I don't remember how these work. Just use False and False.

Please Login or Register  to view this content.