Open file via VBA and paste filename in original file

Hi there,

I want to copy/paste the file name of the file that I opened with VBA into the original file.

So, I have a "master file" (that contains all macros) and I have a "source file". The source file is opened via vba from the master file.

What I want to achieve is that the file name (and FullName) from that source file is transferred to a cell in the master file.

Now I am struggling to get the filename in a variable. Keep getting errors when selecting the first button in the menu form, and I do not understand how to fix that.


Attached: the Master File and the Source File.

Thanks John! That solved my problem :-)

Daniel