Avoid FileNames in Code

[vikas_newports]

Hello
I need your suggestion while writing a long code
I write a code with the help of you experts , I used More than 10 files as a source data for my code
SO I gave them unique names and used in my code too
If someone do not keep the exact names of those file then the macro will be failed.
How can I avoid this type of issue
Also I give the unique name to my Macro enable file and used that name in my code too so If Someone change the macro file name too so the code will not run
So how can I avoid this situation too

[Pete_UK]

Many years ago when I wrote macros for others to use, I used to put my paths and filenames etc. into certain cells of a worksheet, and get that data from those cells within the macro. Another user could easily change those values to suit their own setup on their own PC.

It is easy enough to write some error routines (with appropriate messages) to deal with a particular file not being found on the PC that the macro is running on.

Hope this helps.

Pete

[vikas_newports]

Pete, you are right we can do this I am using thisworkbook.path and filename.ext
Is there any otherway that file name changes in folder doesnt affect my code