New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Way to automate copying from a website into Excel?


Post Reply New Thread Subscribe

 
Thread Tools
edokid

 
Member Since: Aug 28, 2004
Posts: 231
edokid is on a distinguished road

edokid is offline
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

Post Reply New Thread Subscribe


« Trouble with Office for Mac 2011 | assistance »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
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
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

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

All times are GMT -4. The time now is 12:29 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?