Access VBA outside of Excel
 

I have a very large sheet (115M) that I cannot open for some reason
(Excel hangs when I try to open). I can live with out the contents of
the sheet, but would love to be able to get at the VBA that is
contained within modules within the spreadsheet. In fact, I am
desparate, Does anyone have any ideas for how to access this code
without opening the sheet?

I don't really know why the sheet won't open... but it has something
to do with changes Excel made to the sheet during autorecovery
operation.

I am using Excel 2003 in XP-Pro

Thanks,
Rick

Access VBA outside of Excel
 

Did you try Microsoft Office Recovery?

Start Menu - Programs - Microsoft Office - Tools - Microsoft Office
Application Recovery.

" wrote:

I have a very large sheet (115M) that I cannot open for some reason
(Excel hangs when I try to open). I can live with out the contents of
the sheet, but would love to be able to get at the VBA that is
contained within modules within the spreadsheet. In fact, I am
desparate, Does anyone have any ideas for how to access this code
without opening the sheet?

I don't really know why the sheet won't open... but it has something
to do with changes Excel made to the sheet during autorecovery
operation.

I am using Excel 2003 in XP-Pro

Thanks,
Rick

Access VBA outside of Excel
 

Thanks for the reply. If I run this tool after trying to open the
spreadsheet, it cancels out of Excel and gives me the option of
"recovering" the original sheet. Since this is the one that is
corrupted it does not do me any any good. Perhaps if I had run this
when the sheet crashed originally I would be in better shape, but alas
I did not. I have had this sort of thing occur before with large
complicated sheets, and so I think there may be some bug in the auto-
recovery function.

Whatever, I don't really need to solve that, I was just hoping I could
get my VB code out of the corrupted application.
....Rick



On Sep 26, 2:54 pm, Joel wrote:
Did you try Microsoft Office Recovery?

Start Menu - Programs - Microsoft Office - Tools - Microsoft Office
Application Recovery.



" wrote:
I have a very large sheet (115M) that I cannot open for some reason
(Excel hangs when I try to open). I can live with out the contents of
the sheet, but would love to be able to get at the VBA that is
contained within modules within the spreadsheet. In fact, I am
desparate, Does anyone have any ideas for how to access this code
without opening the sheet?

I don't really know why the sheet won't open... but it has something
to do with changes Excel made to the sheet during autorecovery
operation.

I am using Excel 2003 in XP-Pro

Thanks,
Rick- Hide quoted text -

- Show quoted text -

Access VBA outside of Excel
 

Hi Rick,

This sounds like a good reason to keep a backup. I make backup copies
daily of the application I'm developing.

Dan

On Sep 26, 1:25 pm, wrote:
Thanks for the reply. If I run this tool after trying to open the
spreadsheet, it cancels out of Excel and gives me the option of
"recovering" the original sheet. Since this is the one that is
corrupted it does not do me any any good. Perhaps if I had run this
when the sheet crashed originally I would be in better shape, but alas
I did not. I have had this sort of thing occur before with large
complicated sheets, and so I think there may be some bug in the auto-
recovery function.

Whatever, I don't really need to solve that, I was just hoping I could
get my VB code out of the corrupted application.
...Rick

On Sep 26, 2:54 pm, Joel wrote:

Did you try Microsoft Office Recovery?

Start Menu - Programs - Microsoft Office - Tools - Microsoft Office
Application Recovery.

" wrote:
I have a very large sheet (115M) that I cannot open for some reason
(Excel hangs when I try to open). I can live with out the contents of
the sheet, but would love to be able to get at the VBA that is
contained within modules within the spreadsheet. In fact, I am
desparate, Does anyone have any ideas for how to access this code
without opening the sheet?

I don't really know why the sheet won't open... but it has something
to do with changes Excel made to the sheet during autorecovery
operation.

I am using Excel 2003 in XP-Pro

Thanks,
Rick- Hide quoted text -

- Show quoted text -

Access VBA outside of Excel
 

A few remarks.

1) Make sure when you open the file not to enable the macros. You still
will be able to copy the macro out of the file.
2) Even if the file is corrupted, is the maco code corrupted.
3) When MS Office make a backup of the file it creates temp files in the
directory starting with $. You may want to make a copy of the corrupted
file and put it in another directory and then try opening it up. A file can
be corrupt in at least 2 different ways.

a) The file structure is corrupted. Performing a disk check may fix this
problem. If you try to copy the file like I sugested above an you get an
error then this is the cause.
b) The data in the file is corrupted an excel doesn't know how to recover
the file. Usually MS Repair will fix these problems.

" wrote:

Thanks for the reply. If I run this tool after trying to open the
spreadsheet, it cancels out of Excel and gives me the option of
"recovering" the original sheet. Since this is the one that is
corrupted it does not do me any any good. Perhaps if I had run this
when the sheet crashed originally I would be in better shape, but alas
I did not. I have had this sort of thing occur before with large
complicated sheets, and so I think there may be some bug in the auto-
recovery function.

Whatever, I don't really need to solve that, I was just hoping I could
get my VB code out of the corrupted application.
....Rick



On Sep 26, 2:54 pm, Joel wrote:
Did you try Microsoft Office Recovery?

Start Menu - Programs - Microsoft Office - Tools - Microsoft Office
Application Recovery.



" wrote:
I have a very large sheet (115M) that I cannot open for some reason
(Excel hangs when I try to open). I can live with out the contents of
the sheet, but would love to be able to get at the VBA that is
contained within modules within the spreadsheet. In fact, I am
desparate, Does anyone have any ideas for how to access this code
without opening the sheet?

I don't really know why the sheet won't open... but it has something
to do with changes Excel made to the sheet during autorecovery
operation.

I am using Excel 2003 in XP-Pro

Thanks,
Rick- Hide quoted text -

- Show quoted text -