I am wanting to use the code in the below EE link to copy a sheet from another closed workbook.
it says I need ADO and I am not sure what Reference that is.
I am getting the errors in the pic below.
Any advice is appreciated.
I am using 2007