Open file from location using VBA code - file name changes everytime.

Hi,
I need help to write a code to open a User name workbook from a location. This code should be in master file (Update_Report.xls) user will enter data in master file & press button to perform below actions.
Open perticular User name (Cell value B4 in Update_Report) excel workbook from location.
Copy data from master file.
Paste data in user file.
Save & close user file.

Code is as below. Code is not able to locate user file.

Please Login or Register  to view this content.

I am not able to upload master file due to some error. After I press button "Manage Attachments" nothing happens.

Please help me with this.
Thanks in advance.

SWapnil

Hello Swapnil.Kupwade,

Welcome to the Forum!

Since you changed the directory, both workbooks must be in the same directory. If not then the code should be...

Please Login or Register  to view this content.

Check that the file name in cell "B4" contains the file extension, i.e. ".xlsx", ".xlsm", etc.

Thanks
I have tried with ".xls" in cell B4. It is not working. Code gives error for FName not found. I have attached image.
I think I am missing define FName As Varient or similar thing. Please help me to solve the error.
I am sending folders with sample.

Thanks again for the help.

Regards,
SWapnil

FName Error.jpg
TEST.zip

Hello Swapnil.Kupwade,

This should work...

Please Login or Register  to view this content.