Three files: One Excel file that I track inventory (MasterInv), and two auto-generated CSV files (CSV1 and CSV2). I set up Task Scheduler to open all three (CSV files first, then Excel file)
I would like to add VBA to the Excel so when that file opens, it runs the script on the two CSV files. Action to be taken – delete all spaces in Columns C:E on CSV1 and delete all spaces in Column F:F of CSV2.
Can it be done? What would the VBA code look like?
By: Tony Craig