VBA code trouble adding variable to filepath to open copy & paste from another workbook

Hello all, I have been trying for some time now to take this code and make the *** in the file path a variable in say cell A2. As of now this code completes the task I need correctly but I would like to be able to change company data easily as all of the files are downloaded to one folder.

Thank you in Advance for your assistance!

Please Login or Register  to view this content.

Hi
Change your code as follows where fName contains the first part of your file name (change to suit your needs):

Dim wb As Workbook
Dim fName
fName=Range("A1").Value
Application.ScreenUpdating = False ' turn off the screen updating
Set wb = Workbooks.Open("C:\Users\Documents\test\" & fName & " Cash Flow.CSV", True, True)

Hope this helps.
Tony

Tony, I cannot thank you enough, this is exactly what I was looking for!

Thanks for the feedback.
Tony