I am trying to copy an excel file from one server to another. I tried to use filecopy but since the workbook is open, it returns an error.
I know, close the workbook. I wish it were that easy (unless I'm really dumb and unnecessarily complicating it). The excel doc that I am trying to copy has the code to perform the copy. I want it to copy only after other macros are executed. Any ideas on how I can get around this?