F
Frank Pytel
Hello all;
I hope someone has done this already. I want to copy the contents of a
master file into the contents of an old workbook. I want to copy the entire
worksheet, formulas formatting and all.
I recorded this macro:
<--
Sub Copy()
Windows("BlankQuote.xls").Activate
Cells.Select
Selection.Copy
Windows("Q12345678.xls").Activate
Cells.Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=False
End Sub
-->
It works great accept I need to reference workbook Q12345678.xls as
thisWorkbook. This workbook is the older workbook that I would like to update
the worksheet on if a client calls back. The other workbook will always be
BlankQuote.xls. This workbook will be kept up to date at all times.
Can anyone help me with this please?
Thank you.
God Bless
Frank Pytel
I hope someone has done this already. I want to copy the contents of a
master file into the contents of an old workbook. I want to copy the entire
worksheet, formulas formatting and all.
I recorded this macro:
<--
Sub Copy()
Windows("BlankQuote.xls").Activate
Cells.Select
Selection.Copy
Windows("Q12345678.xls").Activate
Cells.Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=False
End Sub
-->
It works great accept I need to reference workbook Q12345678.xls as
thisWorkbook. This workbook is the older workbook that I would like to update
the worksheet on if a client calls back. The other workbook will always be
BlankQuote.xls. This workbook will be kept up to date at all times.
Can anyone help me with this please?
Thank you.
God Bless
Frank Pytel