Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to alter content in a closed spreadsheet without opening it!
I created a spreadsheet with a great macro in! Unfortunately I copied and pasted a formula into all the cells of the sheet (right down to line 65536). The program saved okay, but it's 28MB and won't open! I don't care about the contents of the spreadsheet which I can access using linking to another spreadsheet. What I really want to do is access the macro in the spreadsheet that now won't open. So I was wondering how I can write a macro to write to the sheet in question without opening the file, hopefully delete either the sheet or clear the cell contents for all rows below say row 30 and have it save, so that I can open the file using normal methods. -- mflibra ------------------------------------------------------------------------ mflibra's Profile: http://www.excelforum.com/member.php...o&userid=37449 View this thread: http://www.excelforum.com/showthread...hreadid=572472 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Force content in closed workbook | Excel Discussion (Misc queries) | |||
How do I display textboxes without any content in a spreadsheet? | Excel Discussion (Misc queries) | |||
How do I clear cell content when excel document is closed? | Excel Worksheet Functions | |||
Spreadsheet not opening correctly | Excel Discussion (Misc queries) | |||
Run a macro when opening a spreadsheet | Excel Discussion (Misc queries) |