Open closed workbook, copy/paste, then save as new file

Aviles

Board Regular
Joined
Dec 17, 2008
Messages
161
Hi all, I'm working on a current workbook ('Workbook1') where I would like to copy only the used range data from 'Sheet1', starting from cell A2 (ignoring headers).

I would then like to open a separate, closed workbook ('Workbook2'), go to 'Sheet2', delete rows 2-10 (leaving headers), and paste (values only) the used range of 'Sheet1', 'Workbook1' into cell A2 of 'Sheet2', 'Workbook2'.

Workbook2 path = "S:\Folder1\Folder2\Workbook2.xlsx"

The name and path of Workbook2 will always be the same

I would then like to save 'Workbook2' (SaveAs) using file name "Upload File" & Format (Now, "dd-mm-yy hh.mm") & ".xlsx", into "Folder3" of the same path above. Close/save the newly created "Upload File" and then close the original 'Workbook2' without saving any changes.

Any help would be appreciated. Thanks.
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Forum statistics

Threads
1,143,840
Messages
5,721,101
Members
422,339
Latest member
SHIVATVM

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top