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

54 thoughts on “VBA In Excel File To Run In Separate CSV File

  1. Adipex kaufen

    Please let me know if you’re looking for a article writer for your blog. You have some really great articles and I believe I would be a good asset. If you ever want to take some of the load off, I’d really like to write some articles for your blog in exchange for a link back to mine. Please blast me an e-mail if interested. Regards!

  2. anabole steroide kaufen

    Throughout the grand scheme of things you actually get an A+ for effort. Exactly where you actually confused me ended up being on all the specifics. You know, it is said, details make or break the argument.. And that could not be much more accurate here. Having said that, permit me reveal to you what did deliver the results. The authoring is actually really convincing which is probably the reason why I am making the effort in order to comment. I do not really make it a regular habit of doing that. Second, despite the fact that I can easily see the jumps in reason you come up with, I am not sure of just how you appear to unite the points that help to make the final result. For the moment I will yield to your position however trust in the near future you actually link the dots much better.

Comments are closed.