Hello i made a macro that uploads files, using FileToOpen in vba that Browses for your File and Imports Range in a cell with output that looks something like this:
My question is there a formula or some other way to get only the file name, or in other words - Test.pdf in the above example, displayed in the cell(or some other "display only" cell)? This must not change the value of the cell because i need the whole file location string to upload the file.
Im sorry if its trivial question, thanks in advance.
VBA Code:
C:\Users\User\Desktop\Example Folder Name\Test.pdf
My question is there a formula or some other way to get only the file name, or in other words - Test.pdf in the above example, displayed in the cell(or some other "display only" cell)? This must not change the value of the cell because i need the whole file location string to upload the file.
Im sorry if its trivial question, thanks in advance.