When I open a file through a macro, it doesn't show up in the recents. How can I make it show up?
https://pasteboard.co/HIKhF6S.jpg
Code:
Sheets("RAW DATA").Select Range("A2:K2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Workbooks.Open Filename:= _
"\\blah\blah\blah\Elimination Mapping - CURRENT.xlsx"
Sheets("IntercompanyEliminationGL").Select[IMG]https://pasteboard.co/HIKhF6S.jpg[/IMG]
Range("A2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
https://pasteboard.co/HIKhF6S.jpg
Last edited: