S steve_4477 Registered User. Local time Today, 06:02 Joined Jan 10, 2011 Messages 23 Aug 25, 2011 #1 I know how to export a query to a new Excel Wkbk via vba, but does anyone know how I can easily insert the new sheet directly into an existing workbook?
I know how to export a query to a new Excel Wkbk via vba, but does anyone know how I can easily insert the new sheet directly into an existing workbook?
J JANR Registered User. Local time Today, 13:02 Joined Jan 21, 2009 Messages 1,622 Aug 26, 2011 #2 One of these fuctions would do it: http://www.btabdevelopment.com/ts/default.aspx?PageId=10 JR