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


Thread Tools Search this Thread Display Modes
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
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: 384
Default Re: automating data processing

Try this site:

Reply With Quote

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 06:37 PM.

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