Pasting Book Page

[mmclaug143]

This macro should open up the file (Food room book 2), copy/paste the selected range into the SkutoSkutemplate and then close the page (Foodroom book 2).

Range("A1:J810").Select
Selection.Copy
Windows("SkutoSkuTemplate1").Activate
ActiveSheet.Paste
Windows("\\barracuda\sls_depts\DEPTS\SRG\Logistics\INVENTORY\CSG HALLMARK MASTER INVENTORY\AISLES\Food Room Book 2.0.xlk").Activate
ActiveWindow.Close

 

[DanteAmor]

I did not quite understand what you need.