| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get code from a corrupted workbook
I've just had a file corrupt with a decent chunk of code inside. I've tried
Excel Recovery but it doesn't recover VBA Is there any way to extract the code? Thanks Dave |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get code from a corrupted workbook
Have you tried doing so with OpenOffice (Free 60MB download from www.openoffice.org)
If that's too big a download then by all means fire it on down to me and I'll give it a go for you. You need to take the NOSPAM bit out of my email address -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP ---------------------------------------------------------------------------- Attitude - A little thing that makes a BIG difference ---------------------------------------------------------------------------- "Dave" wrote in message . au... I've just had a file corrupt with a decent chunk of code inside. I've tried Excel Recovery but it doesn't recover VBA Is there any way to extract the code? Thanks Dave |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get code from a corrupted workbook
Downloading - thanks for tip Ken
"Ken Wright" wrote in message ... Have you tried doing so with OpenOffice (Free 60MB download from www.openoffice.org) If that's too big a download then by all means fire it on down to me and I'll give it a go for you. You need to take the NOSPAM bit out of my email address -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "Dave" wrote in message . au... I've just had a file corrupt with a decent chunk of code inside. I've tried Excel Recovery but it doesn't recover VBA Is there any way to extract the code? Thanks Dave |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get code from a corrupted workbook
My pleasure - Hope it works out OK. You will use OpenOffice.calc to open the workbook, and when
it gets there, use Tools / Macro to open the Macro window. Click on any module name in your file and hit Edit, and you should then have a horizontal row of tabs showing you all the modules in the book (Same as Excel's tabbed worksheets) The code may well all be Rem'd out, but you can fix that with an Edit / Replace right where you are in .calc, or once you get it back into Excel. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP ---------------------------------------------------------------------------- Attitude - A little thing that makes a BIG difference ---------------------------------------------------------------------------- "Dave" wrote in message . au... Downloading - thanks for tip Ken "Ken Wright" wrote in message ... Have you tried doing so with OpenOffice (Free 60MB download from www.openoffice.org) If that's too big a download then by all means fire it on down to me and I'll give it a go for you. You need to take the NOSPAM bit out of my email address -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "Dave" wrote in message . au... I've just had a file corrupt with a decent chunk of code inside. I've tried Excel Recovery but it doesn't recover VBA Is there any way to extract the code? Thanks Dave |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get code from a corrupted workbook
Unfortunately the code is gone (???) but the file did open
Thanks for the tip, quite handy Cheers Dave "Ken Wright" wrote in message ... My pleasure - Hope it works out OK. You will use OpenOffice.calc to open the workbook, and when it gets there, use Tools / Macro to open the Macro window. Click on any module name in your file and hit Edit, and you should then have a horizontal row of tabs showing you all the modules in the book (Same as Excel's tabbed worksheets) The code may well all be Rem'd out, but you can fix that with an Edit / Replace right where you are in .calc, or once you get it back into Excel. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "Dave" wrote in message . au... Downloading - thanks for tip Ken "Ken Wright" wrote in message ... Have you tried doing so with OpenOffice (Free 60MB download from www.openoffice.org) If that's too big a download then by all means fire it on down to me and I'll give it a go for you. You need to take the NOSPAM bit out of my email address -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "Dave" wrote in message . au... I've just had a file corrupt with a decent chunk of code inside. I've tried Excel Recovery but it doesn't recover VBA Is there any way to extract the code? Thanks Dave |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get code from a corrupted workbook
Which file did you open - The recovered one or the original corrupt one. OpenOffice is good at
opening corrupt Excel files as well, so give it a go with that. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP ---------------------------------------------------------------------------- Attitude - A little thing that makes a BIG difference ---------------------------------------------------------------------------- "Dave" wrote in message . au... Unfortunately the code is gone (???) but the file did open Thanks for the tip, quite handy Cheers Dave "Ken Wright" wrote in message ... My pleasure - Hope it works out OK. You will use OpenOffice.calc to open the workbook, and when it gets there, use Tools / Macro to open the Macro window. Click on any module name in your file and hit Edit, and you should then have a horizontal row of tabs showing you all the modules in the book (Same as Excel's tabbed worksheets) The code may well all be Rem'd out, but you can fix that with an Edit / Replace right where you are in .calc, or once you get it back into Excel. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "Dave" wrote in message . au... Downloading - thanks for tip Ken "Ken Wright" wrote in message ... Have you tried doing so with OpenOffice (Free 60MB download from www.openoffice.org) If that's too big a download then by all means fire it on down to me and I'll give it a go for you. You need to take the NOSPAM bit out of my email address -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "Dave" wrote in message . au... I've just had a file corrupt with a decent chunk of code inside. I've tried Excel Recovery but it doesn't recover VBA Is there any way to extract the code? Thanks Dave |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get code from a corrupted workbook
I saw this go by on the PowerPoint newsgroup recently:
"John O wrote: 'Next time someone runs across a corrupted Ppt doc try this tool. In Word, do File - Open and choose file type "recover text from any document". This pulls out the text off slides, from speaker notes, from everywhere. It won't be clean, but if you need this...' I just tried it on some oddball files and it works really well. Gotta give credit to Woody for the tip." I tried this with a short bit of Excel VBA code, and I did see it in there, sort of, all choppy and mixed with garbage, barely decipherable, but it might work differently with different files, and you might just get enough to remember what you did. Let us know. Bruce Cooley "Dave" wrote in message . au... : I've just had a file corrupt with a decent chunk of code inside. I've tried : Excel Recovery but it doesn't recover VBA : : Is there any way to extract the code? : : Thanks : : Dave : : |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get code from a corrupted workbook
I don't believe VBA saves your code as text. It's "tokenized", which explains the "garbage" that
are the binary codes for various operators, functions, etc. The legible text probably is your procedure names and quoted text, etc. On Mon, 08 Sep 2003 04:19:07 GMT, "Bruce Cooley" wrote: I saw this go by on the PowerPoint newsgroup recently: "John O wrote: 'Next time someone runs across a corrupted Ppt doc try this tool. In Word, do File - Open and choose file type "recover text from any document". This pulls out the text off slides, from speaker notes, from everywhere. It won't be clean, but if you need this...' I just tried it on some oddball files and it works really well. Gotta give credit to Woody for the tip." I tried this with a short bit of Excel VBA code, and I did see it in there, sort of, all choppy and mixed with garbage, barely decipherable, but it might work differently with different files, and you might just get enough to remember what you did. Let us know. Bruce Cooley "Dave" wrote in message .au... : I've just had a file corrupt with a decent chunk of code inside. I've tried : Excel Recovery but it doesn't recover VBA : : Is there any way to extract the code? : : Thanks : : Dave : : |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| corrupted shared excel workbook | Excel Discussion (Misc queries) | |||
| Excel 2007 says a workbook is corrupted when it isn't | Excel Discussion (Misc queries) | |||
| Excel workbook is corrupted, workbook automatically saves on start | Excel Discussion (Misc queries) | |||
| workbook code | Excel Worksheet Functions | |||
| copy and paste using code from workbook to workbook | Excel Discussion (Misc queries) | |||
![Dave[_15_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
