VBA

The UK's most regular instructor-led training courses.
Training information: financial excel course london · Excel training london · VBA courses London

Resolved · Low Priority · Version 2003

VBA

Christopher has attended:
Excel Advanced course
Excel VBA course

by - delegate Christopher [3 posts] (2008 Apr 29 Tue, 12:05) Reply

How can I copy a range from one sheet then paste the data to another sheet on a different drive

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

Copy Data to Workbook on another drive

by - trainer Carlos gold contributer [479 posts] (2008 Apr 29 Tue, 13:06) Reply

Hi Christopher

The code below allows you to copy data from one workbook and paste it in a workbook on another drive.

Note you open the target workbook, paste the data and then close it saving the new data.

Sub CopyData

Dim WSheet As String

WSheet = "D:/NewWorkbook.xls" 'The path of the target workbook

Range("A1:G1").Copy
Workbooks.Open Filename:=WSheet 'Opens the workbook in the other drive
Sheets("Sheet1").Select
Range("A1").Select
ActiveSheet.Paste
ActiveWorkbook.Close SaveChanges:=True 'Closes the target workbook and saves changes

End Sub

Hope this helps

Carlos