Hi all,
Just curious if it's at all necessary to physically open a spreadsheet in order to copy information to another workbook? Could one not possibly just list the range and file path you want copied?
Currently my code is having to open a file, select contents and then paste into another workbook on a specific tab and then close that file. I'd preferably not want the user to see the file physically opening in the toolbar and then closing if even just for the slightest fraction of a second.
Workbooks.Open Filename:="\\server\shared\Project Zeus\Report X.xls"
Range("A1:X65536").Copy
Workbooks("Reporting model - GM").Sheets(5).Cells(1, 1).PasteSpecial Paste:=xlPasteValues
Windows("Report X.xls").Close
Bookmarks