I have a code that opens a new workbook and pastes into it from another workbook. I have several workbooks that will use this code so what I want to do is be able is have excel see if the new workbook (which is unsaved and only a temporary holding place to compile data from multiple workbooks) is already open and paste the data at the end of the existing workbook rather than creating another new workbook. Since I'm not saving it I can't tell it to look for a specific file path/name. It has to work w/o saving. So it boils down to how can i have excel check if NSRReport is open?
Set NSRReport = Workbooks.Add() Set sh2 = NSRReport.Sheets("Sheet1") Set sh3 = G_Report lastrow2 = sh3.Range("A" & Rows.Count).End(xlUp).Row sh3.Range("A1:I1").Copy sh2.Range("A1").PasteSpecial sh3.Range("A1:A3001").AutoFilter Field:=1, Criteria1:="<>" sh3.Range("A2:I" & lastrow2).Copy sh2.Range("A2").PasteSpecial Paste:=xlPasteValues sh2.Columns("A:I").AutoFit
This question generated 23 answers. To proceed to the answers, click here.
This thread is current as of April 23, 2014.