Here is my query. Is there a way to right in code that would tell excel to activate or select the workbook that the macro is located in.
example: I have a macro that opens another workbook and copies several cells from that workbook. Then I need to paste those copied cells into a the workbook that the macro was written in or associated with. I know I could do this buy using the file name of the
destination sheet, but that changes regularly. but the same macro will always be associated with a given workbook no matter what the workbook name. If anyone out here has any idea if this is possible I would apreciate the help.
example: I have a macro that opens another workbook and copies several cells from that workbook. Then I need to paste those copied cells into a the workbook that the macro was written in or associated with. I know I could do this buy using the file name of the
destination sheet, but that changes regularly. but the same macro will always be associated with a given workbook no matter what the workbook name. If anyone out here has any idea if this is possible I would apreciate the help.