Pasting Book Page

mmclaug143

New Member
Joined
Aug 14, 2019
Messages
2
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
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,594
Office Version
  1. 2007
Platform
  1. Windows
I did not quite understand what you need.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,023
Messages
5,575,631
Members
412,680
Latest member
TSpan
Top