The single worksheet retains the Name and CodeName properties of the source worksheet. If the copied worksheet held a worksheet code sheet in a VBA project, that is also carried into the new workbook. An array selection of multiple worksheets can be copied to a new blank Workbook object in a similar manner. Step 1: Capture the file path. First, you’ll need to capture the full path where the Excel file is stored on your computer. For example, let’s suppose that an Excel file is stored under the following path: C:\Users\Ron\Desktop\ Product List.xlsx. In the Python code, to be provided below, you’ll need to modify the path name to reflect the.