Extract tables and saved in one excel file


When you want the result to write in one excel sheet, then as you mentioned table.TableName just replace this with Sheet1

and instead of write Range use Append Range

because everytime loop runs the sheet you specify is Sheet1 and it will append the data instead of write range

Hope this may help you


1 Like