Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving only values
I believe this is simple I just don’t know how to do it. Lets say I have a file called “Maker” that gets its data for various places. I want to SAVE this as “Maker II” but only now with the values of the cells not the actual links. Thank you for your help. -- sungen99 ------------------------------------------------------------------------ sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144 View this thread: http://www.excelforum.com/showthread...hreadid=564808 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving only values
with workbooks("Maker.xls")
for each sh in .worksheets sh.cells.formula = sh.cells.value next .SaveAs Thisworkbook.path & "\Maker II.xls" end with -- Regards, Tom Ogilvy "sungen99" wrote: I believe this is simple I just dont know how to do it. Lets say I have a file called €śMaker€ť that gets its data for various places. I want to SAVE this as €śMaker II€ť but only now with the values of the cells not the actual links. Thank you for your help. -- sungen99 ------------------------------------------------------------------------ sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144 View this thread: http://www.excelforum.com/showthread...hreadid=564808 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving only values
Tom, I did the following with your code but it seems to just lock my computer up. Made this a button macro. Should it be used someother way? __________________________________________________ __________ Sub Button5_Click() With Workbooks("Maker.xls") For Each sh In .Worksheets sh.Cells.Formula = sh.Cells.Value Next ..SaveAs ThisWorkbook.Path & "\Maker II.xls" End With End Sub -- sungen99 ------------------------------------------------------------------------ sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144 View this thread: http://www.excelforum.com/showthread...hreadid=564808 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving only values
This might help. But I wouln't see it locking anything up.
Sub Button5_Click() dim calc as Long calc = Application.Calculation Application.Calculation = xlManual With Workbooks("Maker.xls") For Each sh In .Worksheets sh.Usedrange.Cells.Formula = sh.UsedRange.Cells.Value Next .SaveAs .Path & "\Maker II.xls" End With Application.Calculation = xlAutomatic End Sub -- Regards, Tom Ogilvy "sungen99" wrote: Tom, I did the following with your code but it seems to just lock my computer up. Made this a button macro. Should it be used someother way? __________________________________________________ __________ Sub Button5_Click() With Workbooks("Maker.xls") For Each sh In .Worksheets sh.Cells.Formula = sh.Cells.Value Next .SaveAs ThisWorkbook.Path & "\Maker II.xls" End With End Sub -- sungen99 ------------------------------------------------------------------------ sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144 View this thread: http://www.excelforum.com/showthread...hreadid=564808 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving only values
Works flawlessly! Thank you Tom! -- sungen99 ------------------------------------------------------------------------ sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144 View this thread: http://www.excelforum.com/showthread...hreadid=564808 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
saving values without formulas? | Excel Discussion (Misc queries) | |||
Automaticly saving formula's to values when saving | Excel Discussion (Misc queries) | |||
saving values to cells | New Users to Excel | |||
Saving Values | Excel Programming | |||
Saving values during installation of Add-In | Excel Programming |