Want to Get Rid of File Name Used in Coding

[crouching_tiger]

Hi,

I am using the below code to copy data from one file and paste it to another file. Before the below code runs it opens a file from a specific path in the shared drive and then starts pasting the data which i have in my currently opened file.

Please Login or Register  to view this content.

As you guys can see i have used the file name in coding, whenever someone changes the file name the code throws. "Subscript out of range" error. I am a very new programmer, i would like to know how can i assign the name dynamically in my coding so that the change of name of the file doesnt impact the functionality of the code.

Thanks in advance

[AndyLitch]

Instead of specifying by name you can use :-
> ThisWorkbook to refer to the workbook where the code is
> ActiveWorkbook to refer to the workbook in use

[crouching_tiger]

Thanks Andy. It worked