VBA to copy sheet to another workbook without locking the source?

[damian_r_Home]

Afternoon all.

I put a post up a few days ago about a way of doing this and have since decided that perhaps VBA is the way to go.

https://www.mrexcel.com/forum/excel...ically-copy-entire-sheet-one-xls-another.html

Anyway, a brief description of what i am looking to do is as follows.


I have a spreadsheet that needs to pull data from another spreadsheet but without locking up the source

The duplicate spreadsheet is
C:\DJR\test duplicate\Duplicate.xlxs

The source spreadsheet is located at
C:\DJR\test duplicate\Source.xlxs

I need sheet named DRGS in source to be copied into sheet 1 of the duplicate spreadsheet.

Can anyone help with writing the VBA in duplicate sheet 1 at all?

Thanks in advance.

T