Can someone provide an example vb script or macro which can perform the following:
1. Open file.xlsx
2. Set Column B to 'Sort Ascending A-Z'
3. Insert a table from 'Cell A-1 through Cell J-681'
4. Save file.xlsx
5. Close Excel.
The Cell range for the table needs to be able to edit if needed...