I know that you can use
in the immediate window to do this. But this also shows the File path. How can I show only the FileName? Is it possible?Please Login or Register to view this content.
I know that you can use
in the immediate window to do this. But this also shows the File path. How can I show only the FileName? Is it possible?Please Login or Register to view this content.
This will default to the workbook name
Or this...Please Login or Register to view this content.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks