Copy from workbk & Paste to project window
 

Is there a way to write a macro of function that would copy from a worksheet.
then open VBA GoTo.mymacro then select all from that module and then paste what I originally had copied.


Filename changes daily. would like to set up a macro to replace Filename daily

I can copy get VBA open and go to specific macro. As far as I have gotten.

any help would be very much appreciated.