Go Back   MarcomCentral (PTI) and FusionPro User Communities > Support > Digital Workflow Documents

Notices

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old June 24th, 2009, 05:04 PM
rpaterick rpaterick is offline
Senior Contributor
 
Join Date: Mar 2009
Posts: 427
Default automating data processing

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?

Reply With Quote
  #2  
Old July 7th, 2009, 02:44 PM
Alex Marshall's Avatar
Alex Marshall Alex Marshall is offline
FusionPro VDP Support
 
Join Date: Sep 2008
Location: Chicago,Illinois
Posts: 380
Default Re: automating data processing

Try this site:

http://www.automateexcel.com/
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -7. The time now is 11:51 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) 2011, PTI Marketing Technologies™, Inc.