Why not
convert to values
copy to NEW
rename
save
close
close original
-----Original Message-----
From: rajan verma
Sent: Sunday, September 11, 2011 1:23 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Moving Sheets
Hi
Try This
Sub GetALlSheet()
Dim sh As Worksheet
Dim wb As Workbook
Set wb = ActiveWorkbook
Application.Workbooks.Add
For Each sh In wb.Sheets
sh.Copy ActiveWorkbook.Sheets(1)
ActiveSheet.Cells.Copy
Selection.PasteSpecial Paste:=xlPasteValues,
Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Next
ActiveWorkbook.SaveAs "D:\MyWorkbook"
ActiveWorkbook.Close
End Sub
http://excelpoweruser.blogspot.com/2011/08/making-different-workbook-without.html
On 9/10/11, bom <xlbo...@gmail.com> wrote:
I would like to know whether its possible to move sheets from one
workbook to another without the formulas on the sheets moved being
changed?
For example I want to move two sheets from one workbook to another.
One of those sheets populates info from the other sheet that is being
moved with it. when I moved them to the other workbook, I don't wanna
have any info of the previous workbook in the formula bar.
Hope you understand what I am trying to say.
Regards.
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
Regards
Rajan verma
+91 9158998701
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel