Automated Save and worksheet?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

deeners - 25 Jul 2007 15:28 GMT

How do I set it up to create a new worksheet that pulls the data from
a different sheet or workbook and then save it to a different name? Is
that possible?

Thanks!

Reply to this Message

Jim Gordon MVP - 25 Jul 2007 18:02 GMT

Hi,

Yes, it is possible. A variety of technologies can be used for this.

Pulling data can be done using ODBC. Saving can be done via AppleScript or
Visual Basic for Applications.

Can you give us more information about the data source, what kind of data
you wish to pull from the source, and whether or not you are comfortable
with AppleScript or Visual Basic, and whether or not you need to share this
solution with other computers or just on your Mac.

Thanks.

-Jim

Quoting from "deeners" <deeners@gmail.com>, in article
1185373734.120934.232460@q75g2000hsh.googlegroups.com, on [DATE:

> How do I set it up to create a new worksheet that pulls the data from
> a different sheet or workbook and then save it to a different name? Is
> that possible?
>
> Thanks!

Signature

Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info http://mvp.support.microsoft.com/

Reply to this Message

deeners - 26 Jul 2007 00:32 GMT

I need to create a database for work. We need each case manager to
have their own database and by boss wants one that compiles all the
data so he can keep tabs on it in one worksheet. We use windows at
work and I have a mac at home. I am new to vba and apple scrips but
willing to learn.

Thanks,

On Jul 25, 1:02 pm, Jim Gordon MVP <goldke...@WarmerThanWarmMail.com>
wrote:

> Hi,
>
[quoted text clipped - 27 lines]
> MVPs are not Microsoft Employees
> MVP infohttp://mvp.support.microsoft.com/

Reply to this Message

Bob Greenblatt - 26 Jul 2007 12:56 GMT

On 7/25/07 7:32 PM, in article
1185406335.003889.157100@q75g2000hsh.googlegroups.com, "deeners"

> I need to create a database for work. We need each case manager to
> have their own database and by boss wants one that compiles all the
[quoted text clipped - 4 lines]
> Thanks,
> :D

Search help for consolidate, and shared workbooks. Either or both in
combination seem like what you want.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

Mac Forum / Applications / Excel / July 2007

Automated Save and worksheet?