How to reference file paths given in text box on user form by a user and then perform execution using command buttons on the given file path.

[Shriddhi Parab]

Hello All,

I have certain tasks to be performed for which I have my command buttons on a user form. what I need to do and facing difficulty is that I want the user to input his/her required file name in a text box on the user form and the command buttons should perform execution on that file name.

for eg :
------------example of form lay out starts------
Please enter file name : C:\macro\abc.xls

Command : High Light Duplicates.
Command : Delete Duplicate
Command : Add Codes.

----------example of form lay out ends---------

Now the file name given by user, I need to reference it as input for operations written in the vba codes for command buttons given as above. It totally depends on the user on which action he /she needs to perform.

Please help me with different workbook referencing.

 

[Shriddhi Parab]

I have my codes ready for command buttons .. I need help in referencing file name given by user in text box and how will I link my command button codes to perform execution on the file name.