Including VBA code to copy filepath to cell range

[kenadams378]

Hi,

In my macro, my code will open a number of files to extract data into seperate tabs. My query is, when the code opens the files i want to paste the filepath of these files into a cell on source tab of the macro?

The souce tab of the macro is called 'Start'

Is this possible?

[patel45]

attach your code

[kenadams378]

as requested

Please Login or Register  to view this content.

[patel45]

Please Login or Register  to view this content.

[kenadams378]

Apologies, it doesn;t work it is erroring with - object required

based on your instruction the amended code is;

Please Login or Register  to view this content.

[patel45]

Worksheets("Start").Range("B3").value = FName

[kenadams378]

you are a star!

Works!

Thank you so much!!!!