|
| The AccuTerm forum has moved. Go to community.rocketsoftware.com to register for the new Rocket forum. |
|
Post Reply 
|
| Author | |
LiveBlues 
Groupie 
Joined: February 28 2005 Status: Offline Points: 93 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: 2 years in a rowPosted: February 27 2007 at 5:42pm |
|
This is the second year in a row that I have used Pete's great routines to create spreadsheets for all of our reps to take to their accounts, showing them the account activity for the past year.
All said, I might have put 20 hours into the project. I created ~1500 spreadsheets. At a (very) conservative estimate of 30 minutes per spreadsheet, I saved our sales department 750 man hours. Thanks Pete! |
|
 |
|
|
LiveBlues
Groupie
Joined: February 28 2005 Status: Offline Points: 93 |
Post Options
Thanks(0)
Quote Reply
Posted: March 04 2007 at 9:02am |
|
It has been brought to my attention that the above post was a little ambiguous, so I thought I should clarify that the estimate of 30 minutes per spreadsheet was the amount of time it would have taken to create each spreadsheet if done manually.
|
|
|
|
|
giannimaione
Groupie
Joined: April 29 2006 Location: Italy Status: Offline Points: 64 |
Post Options
Thanks(0)
Quote Reply
Posted: March 05 2007 at 8:39pm |
|
Hi LiveBlues,
what is "Pete's great routines to create spreadsheets" ? Thanks, Gianni |
|
|
|
|
LiveBlues
Groupie
Joined: February 28 2005 Status: Offline Points: 93 |
Post Options
Thanks(0)
Quote Reply
Posted: March 06 2007 at 4:52am |
|
Hi Gianni,
If you look in the OBJBP file (if you installed the object bridge programs when you installed), there is a program called UPDATE.EXCEL.SPREADSHEET that I was able to modify to suit my needs. It works quite well. |
|
|
|
|
noranevers
Newbie 
Joined: October 13 2005 Location: United States Status: Offline Points: 10 |
Post Options
Thanks(0)
Quote Reply
Posted: June 18 2007 at 4:04am |
|
I need to do something very similar. Do you mind sharing your routine to create and save the spreadsheets?
|
|
|
|
|
LiveBlues
Groupie
Joined: February 28 2005 Status: Offline Points: 93 |
Post Options
Thanks(0)
Quote Reply
Posted: June 19 2007 at 6:05pm |
|
Sorry for the delay. I've been a bit under the weather lately.
If you would like to give me some details about what you are trying to accomplish, I will see if I can help you out a bit. Please email your questions to LiveBlues*removethis*@gmail.com, I will see if I can head you down the right path. |
|
|
|
|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
2 years in a row
Topic Options