I have an xlsx file with 7 columns, and I would like to copy 3 of the columns (including headers)to a newly created file. However, I’ve been having problems with “Write Range”.
SourceFile Path: C:\Users\lekan\Desktop\SourceFile.xlsx
DestinationFile Path: C:\Users\lekan\Desktop\DestinationFile.xlsx
Columns to copy are: Customer ID, Customer Country, Phone Number, Quantity
Thanks a lot guys!