I am using the code below to export an Excel spreadsheet to a new workbook. I want to use the same file name and update Sheet2 as I will be using a pivot table on Sheet 1. Any other suggestions will be helpful also... I need help with how to:
1. Delete Sheet2 in workbook before adding new data.
![]()
Please Login or Register to view this content.
Bookmarks