Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy File Formulas between Files w/o the link
Is there a way to copy a Excel file with just formulas (not data) and apply
it to another file w/o the copied file link included? I have a program which spits out a xls file for each data set generated and I'd like to manipulate the data repeatedly for each file w/o having to generate the doggone formulas each time. Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy File Formulas between Files w/o the link
Let's say we have two workbooks, Book1.xls and Book2.xls. Each has Sheet1.
Here is a trick for high speed. Rather than copying individual cells with formulas, we copy the entire sheet and then remove the non-formulas. (only a single copy/paste): Sub copy_formula() Set w1 = Workbooks("Book1") Set w2 = Workbooks("Book2") w1.Sheets("Sheet1").Cells.Copy w2.Sheets("Sheet1").Range("A1") w2.Activate Sheets("Sheet1").Activate For Each r In ActiveSheet.UsedRange If r.HasFormula Then Else r.Clear End If Next End Sub -- Gary''s Student - gsnu200761 "PJ in CO" wrote: Is there a way to copy a Excel file with just formulas (not data) and apply it to another file w/o the copied file link included? I have a program which spits out a xls file for each data set generated and I'd like to manipulate the data repeatedly for each file w/o having to generate the doggone formulas each time. Thank you |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy File Formulas between Files w/o the link
One method....
F5SpecialFormulasOK EditReplace What: = With: ^^^ Replace all. Copy to the new workbook/worksheet and then reverse the process of EditReplace. Gord Dibben MS Excel MVP On Tue, 11 Dec 2007 15:54:01 -0800, PJ in CO <PJ in wrote: Is there a way to copy a Excel file with just formulas (not data) and apply it to another file w/o the copied file link included? I have a program which spits out a xls file for each data set generated and I'd like to manipulate the data repeatedly for each file w/o having to generate the doggone formulas each time. Thank you |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy File Formulas between Files w/o the link
"Gord Dibben" wrote: One method.... F5SpecialFormulasOK EditReplace What: = With: ^^^ Replace all. Copy to the new workbook/worksheet and then reverse the process of EditReplace. Gord Dibben MS Excel MVP On Tue, 11 Dec 2007 15:54:01 -0800, PJ in CO <PJ in wrote: Is there a way to copy a Excel file with just formulas (not data) and apply it to another file w/o the copied file link included? I have a program which spits out a xls file for each data set generated and I'd like to manipulate the data repeatedly for each file w/o having to generate the doggone formulas each time. Thank you Thank you Both for your reply - I haven't attempted the first method yet, but will when I attempt to automate the number crunching. The second method described worked just fine. Thank you again. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I find what files link into a source file in Excel? | Excel Worksheet Functions | |||
Copy a file with only values no formulas | New Users to Excel | |||
What files link to this file? | Excel Discussion (Misc queries) | |||
CHK file in excel link files | Excel Worksheet Functions | |||
Can I embed or link multiple .pdf files into or to an excel file? | Excel Discussion (Misc queries) |