I want to know if it is possible to copy a workbook within Excel.
I am not talking about Workbook.SaveCopyAs, which takes the active workbook and saves another copy somewhere, but the result is only one copy in memory, the one with the new name.
I am trying to avoid reloading the original file because this is being done over a network that has more bugs than a third world tenement house.
Any way to do it? Copy a workbook within an instance of Excel (name won't matter, especially if I can specify one)?
Bookmarks