Dear Gurus,

i'm newbie on macro, now i try to consolidate some record from diffrent file ( file A, file B and etc ) into one master file ( file master ). below are the result when i try to using record macro

--------------------------
Sub DATA1()
'
' DATA1 Macro
'

'
ChDir "C:\New Folder"
Workbooks.Open Filename:= _
"C:\New Folder\File A.xlsm"
Sheets("Data").Select
Range("A11:G11").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Windows("File Master").Activate
ActiveSheet.Paste
Windows("File A.xlsm").Activate
ActiveWindow.Close
Workbooks.Open Filename:= _
"C:\New Folder\File B.xlsm"
Sheets("Data").Select
Range("A11:G11").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Windows("File Master").Activate
ActiveSheet.Paste
Windows("File B.xlsm").Activate
ActiveWindow.Close
Sheets("Dashboard").Select
Range("G14").Select
ActiveSheet.PivotTables("PivotTable1").PivotCache.refresh
End Sub

-------------------------------------

the problem are when i run the code :
1. there is mssg box to enable macro while open the file A, file B etc
2. the number of record from files ( file A, file B etc ) is increse every week, so the last row from file A will be different every week
3. After paste the record to file master, its asking for confirmation to save the information from clipboard or not

my question :
1. how to prevent mssg box for enable macro appear?
2. how to put the cursor to empry cell right after the last record from the file A
3. how to confirm the mssg box when closing the file

appreciate if you guys can help me on this

thank you in advance


neb.