Summary: I need to be able to pull columns of data from different spreadsheets adhoc. This data then needs to be available as a CSV file.
Detail: I require a script the can pull specific columns from specific worksheets in Excel and import them to a new workbook as CSV format.
I can do this via a Macro but i want to be able to run the script outside of Excel, Ideally I would be prompted by the script to specify the source Excel file to pull from and specify the output file location and name.
39 freelancers are bidding on average £50 for this job
Hi, i can build a tool in VB.NET to do what you want exactly and if checked my projects and reviews you will find that i am good with this type of projects :) Proposed Milestones £50 GBP - Project Milestone