Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I access the access data via Excel 2002 with auto update ? | Excel Programming | |||
Importing data from Access to Excel, but I need to vary the table from Access | Excel Programming | |||
export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) | |||
Access data -work in Excel- save in Access | Excel Programming | |||
Getting Access Error Messages when running Access through Excel | Excel Programming |