| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove formulas and links from 500 workbooks
Hi Nathan
Not possible without opening the files Look at this example that copy a range to all workbooks in a folder http://www.rondebruin.nl/copy4.htm You can change the copy code for code on this page to make values. http://www.rondebruin.nl/values.htm If you need help post back -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Nathan" <nathan@123 wrote in message ... Hi, I need to know how I can remove formulas and links (and replace with current values) from 500 workbooks without opening each workbook. I would like to be able to point to a folder and then let the program do the rest. We want to archive this data, and with the formulas and links in place it is a little awkward. TIA Nathan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Slow opening links between workbooks with links created in 2003 | Excel Discussion (Misc queries) | |||
| Copy formulas between workbooks without copying links | Excel Discussion (Misc queries) | |||
| Updating Workbooks from multiple links Workbooks | Excel Worksheet Functions | |||
| remove links when pasteing formulas from one workbook to anoth | Excel Worksheet Functions | |||
| My sumif formulas containin links to other workbooks do not calcul | Excel Worksheet Functions | |||
Linear Mode
