Prev: Type mismatch
Next: Auto format sheet
From: Dee Sperling on 2 Apr 2010 12:12
Each time this macro is run, it's done on a brand new spreadsheet, so storing
it in the current spreadsheet wouldn't work.

Is it possible to programmatically store the information input by the user
to the PERSONAL.XLS spreadsheet, save the PERSONAL.XLS spreadsheet so they
don't get prompted when closing Excel, and then go get that information the
next time a new spreadsheet is opened?

"Gary''s Student" wrote:

> Sure. Once the user has supplied the info, have the macro store it in some
> cells somewhere.
>
> The next time the program runs, the macro should first look at the storage
> area and ask for data only if it is empty.
> --
> Gary''s Student - gsnu201001
>
>
> "Dee Sperling" wrote:
>
> > The macro prompts for the user's name and email address. Is there any way to
> > have the macro store that information for the next time, instead of asking
> > each time it's run?
> >
> > Thank you,
> > Dee Sperling
 | 
Pages: 1
Prev: Type mismatch
Next: Auto format sheet