dynamic workbook/sheet reference in VBA macro

[johannesk]

Hi,
I am trying to load (Copy)certain data from a file from fixed location into a current file by macro. The file name of the current file will change all the time so I need a dynamic reference. I tried the active workbook command, but somehow it doesn't work. Do I have a syntax error? please see below, and thanks for your HELP!


Range("A1").Select
Workbooks.Open Filename:="M:\MasterData\Supplier_Payee_Master.xlsm"
Range("A1:C2203").Select
Selection.Copy
Windows("ActiveWorkbook.fullname").Activate
Range("A1").Select
ActiveSheet.Paste