rpaterick Posted June 25, 2009 Share Posted June 25, 2009 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? Link to comment Share on other sites More sharing options...
Alex Marshall Posted July 7, 2009 Share Posted July 7, 2009 Try this site: http://www.automateexcel.com/ Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.