If I were doing it, I would not use the name ThisWorkbook because that is a
reserved name for Excel workbooks. Using reserved names can cause problems
when running code, because the compiler sees those names as costants that
represent predetermined objects. Maybe a name like "OriginalWB" would be a
better idea.


"Frank Pytel" wrote in message
...
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