将VBA转换为VBScript以删除列中的重复项

I have a sheet in an Excel file in which I want to remove duplicate values from column 1. In Excel it has this feature when you click under Data, then Remove Duplicates on the column named "Code" which is the first column. I am trying to translate this as a VBScript, unsure how. I tried recording a macro to grab the VBA syntax but it isn't the same for VBScript. The code I get from the recorded macro is I have a sheet in an Excel file in which I want