| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save sheet as new file w/o refs to original?
Thanks, Tom. I had a problem, though: run-time error 1004 - "PasteSpecial
method of Worksheet failed". Help said the xlValues was only available to the Range object, so I changed ActiveSheet to ActiveSheet.Range("A1") and it worked okay. Is this just a difference, perhaps, in versions (I'm using XL2000 with Win2000)? Or did I do something wrong? Ed "Tom Ogilvy" wrote in message ... It isn't that hard: Activesheet.copy Activesheet.cells.copy Activesheet.pasteSpecial xlValues ActiveWorkbook.SaveAs "MyUnlinkedCopy.xls" -- Regards, Tom Ogivly "Ed" wrote in message ... Is it possible to save a sheet as a separate new file with a single command and carry over everything EXCEPT references to the original file? I tried it, but instead of values only I get formulas with references back to the original workbook. Or will I need to open a new book and do a series of Paste Specials (values, column widths, formats, etc.)? Ed |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save sheet as new file w/o refs to original?
No. Its called a typo:
Activesheet.copy Activesheet.cells.copy Activesheet.cells.pasteSpecial xlValues ActiveWorkbook.SaveAs "MyUnlinkedCopy.xls" although range("A1") would work as well. -- Regards, Tom Ogilvy "Ed" wrote in message ... Thanks, Tom. I had a problem, though: run-time error 1004 - "PasteSpecial method of Worksheet failed". Help said the xlValues was only available to the Range object, so I changed ActiveSheet to ActiveSheet.Range("A1") and it worked okay. Is this just a difference, perhaps, in versions (I'm using XL2000 with Win2000)? Or did I do something wrong? Ed "Tom Ogilvy" wrote in message ... It isn't that hard: Activesheet.copy Activesheet.cells.copy Activesheet.pasteSpecial xlValues ActiveWorkbook.SaveAs "MyUnlinkedCopy.xls" -- Regards, Tom Ogivly "Ed" wrote in message ... Is it possible to save a sheet as a separate new file with a single command and carry over everything EXCEPT references to the original file? I tried it, but instead of values only I get formulas with references back to the original workbook. Or will I need to open a new book and do a series of Paste Specials (values, column widths, formats, etc.)? Ed |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I undo a "save file" to revert back to original spreadsheet | Excel Discussion (Misc queries) | |||
| auto save excel file every 10 minutes to its original file name | Excel Discussion (Misc queries) | |||
| Auto save replaced my original file and now I need the original? | Excel Discussion (Misc queries) | |||
| Save sheet as new file w/o refs to original? | Excel Programming | |||
| VBA to Save a file to a different format but keep original | Excel Programming | |||
Linear Mode
