VBA

Resolved · Low Priority · Version 2003

Tue 29 Apr 2008, 12:05 Delegate Christopher said...

Christopher has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

VBA

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

Tue 29 Apr 2008, 13:06 Trainer Carlos said...

Copy Data to Workbook on another drive

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