rpaterick
June 24th, 2009, 06:04 PM
Anyone know how to automate excel functions?
Deleting rows, deleting columns, add column headers, merging sheets?
Or know a program that could do all this stuff that has been tested?
I have a campaign that the customer submits excel files with extra rows(rows that are combined together, arggghh) for it's internal review and has 2, 3, and more sheets sometimes that needed to be merged together. Also has multiple excel files that would have to have all this stuff done to it and then all the excel files would then be merged into one.
Not sure if a script could do this in text editor and then covert to a .bat file?
:eek:
Deleting rows, deleting columns, add column headers, merging sheets?
Or know a program that could do all this stuff that has been tested?
I have a campaign that the customer submits excel files with extra rows(rows that are combined together, arggghh) for it's internal review and has 2, 3, and more sheets sometimes that needed to be merged together. Also has multiple excel files that would have to have all this stuff done to it and then all the excel files would then be merged into one.
Not sure if a script could do this in text editor and then covert to a .bat file?
:eek: