Way to automate copying from a website into Excel?

leemoreau · leemoreau #1 (**permalink**)

01-28-2012, 10:16 AM

Hey everyone not sure if this is possible or if there's an app or way to do this in Automator but here's my situation. I use Salesforce.com for our CRM. I need to frequently copy a few items from Salesforce and paste it into an Excel file as a new row. So for example Salesforce may be set up with two columns:

Account Name............................Opportunity Amount
Sales Rep..................................Order Type
Install Date................................Contract Term

Etc. Those are always in the same spot in Salesforce, or could be if I had the screen maximized. In Excel, I have a workbook with then basically 6 columns:

Account Name...Opportunity Amount...Sales Rep...Order Type

etc.

I want a way that I can go into an opportunity in Salesforce, press a script or application, and have it copy those 6 fields, and then paste them into a new row in the Excel workbook to save me having to manually copy and paste each one. So basically like a Macro I guess but not sure if Automator can do that or if anyone has any suggestions?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Unable to Connect to Specific Website	raqk8	OS X - Operating System	5	05-31-2011 06:37 PM
Making a website	Minimadj	Web Design and Hosting	4	04-12-2011 03:21 AM
Can't open big Excel workbook on MacBook Air	SergeiV	OS X - Apps and Games	1	06-01-2010 04:01 AM
MAC excel 08 vs PC excel 07	gcookie	OS X - Apps and Games	2	05-30-2010 11:32 PM

Way to automate copying from a website into Excel?

Internet Services

Web Development

Digital Marketing

Consumer Tech

leemoreau #1 (permalink)
Member Since: Aug 28, 2004 Location: Toronto, ON Posts: 216 Mac Specs: PowerBook G4 12", and iBook G4 12"	01-28-2012, 10:16 AM Hey everyone not sure if this is possible or if there's an app or way to do this in Automator but here's my situation. I use Salesforce.com for our CRM. I need to frequently copy a few items from Salesforce and paste it into an Excel file as a new row. So for example Salesforce may be set up with two columns: Account Name............................Opportunity Amount Sales Rep..................................Order Type Install Date................................Contract Term Etc. Those are always in the same spot in Salesforce, or could be if I had the screen maximized. In Excel, I have a workbook with then basically 6 columns: Account Name...Opportunity Amount...Sales Rep...Order Type etc. I want a way that I can go into an opportunity in Salesforce, press a script or application, and have it copy those 6 fields, and then paste them into a new row in the Excel workbook to save me having to manually copy and paste each one. So basically like a Macro I guess but not sure if Automator can do that or if anyone has any suggestions?
	QUOTE Thanks

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)