VBA In Excel File To Run In Separate CSV File

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

One thought on “VBA In Excel File To Run In Separate CSV File

Leave a Reply

Your email address will not be published. Required fields are marked *