| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to delete all macros - save file with cell-name
Hi,
Is it possible to make a macro that deletes all macro's? I've got a large xls file (7MB) and I want to save only the fill-in cells. I've made a macro that copies the fill-in cells to a sheet and deletes all the others sheets. I use an auto_open macro and after deleting the sheets the auto_open macro cannot be played, so I have te delete it. Second question : How can I save a file with the value (name) of a cell ? ex : A1 = TOM I want to make a marco that saves the file as: Version 1.0 TOM Greez Tom |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2007 Macro to Open File, Delete Contents, Save New File | Excel Discussion (Misc queries) | |||
| Macros Containing a File Save As & Tab Deletions | Excel Discussion (Misc queries) | |||
| save excel file from a table delimited file (.txt) using macros | New Users to Excel | |||
| Delete rows in Excel file with macros | Excel Programming | |||
| Macros in Excel - Save as and rename file | Excel Programming | |||
Threaded Mode
