autosave add-in settings
 

Good morning,

I changed the settings of the autosave add-in (do not prompt before save etc)
but whenever i close excel and load it again it always reset the settings to default values. Is there a way to retain my settings as the new default values? Or is the some coding I can use to automatically reset the values instead of manually having to do it.

Thank you

Daniel

autosave add-in settings
 

Daniel,

I'm not sure if following will work for the autosave addin
but i'd give it a try...

double click the autosave project in vbe.

Use following hint to answer the prompt:
What name do South Africans use for CONNOCHAETES TAURINUS?

(1st letter uppercase, add 2 exclamation marks)

somewhat surprising in relation to their views on public licensing..

cryptic? sure! <VBG


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


?B?RGFuaWVs?= wrote:

Good morning,

I changed the settings of the autosave add-in (do not prompt before
save etc) but whenever i close excel and load it again it always
reset the settings to default values. Is there a way to retain my
settings as the new default values? Or is the some coding I can use
to automatically reset the values instead of manually having to do it.

Thank you

Daniel

autosave add-in settings
 

I had to install it to be able to check..


you can do it much simpler...

In Excel:
select the settings you want.

Open the VBEditor
make sure Project window and immediate window are visible.

In the Project Explorer select Autosave.xla
In the Immediate Pane type thisworkbook.s

Done.



The hard way would be (and for your curiosity ?)

thisworkbook.isaddin = false
now goto sheet 'LocTable'
the settings are stored in range K8:15

k8 named [ud01n.Do_Save] is a boolean Save/DontSave
k10 named [ud01n.Frequency1] is the frequency in minutes
k12 named [ud01n.Save.Option is 1 for active workbook
is 2 for all workbooks
k15 named [ud01b.Prompt] is a boolean Prompt/NoPrompt


before saving make sure you set
thisworkbook.isaddin to TRUE


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


?B?RGFuaWVs?= wrote:

It works, BUT , even when I gain access to the code I cannot figure
out what I need to change?

what lines of code need to be changed or added so that all open
workbook get saved (by default), so that the user doesn't get prompted
to save (just does it automatically, by default) and so that it save
every 22 minutes (by default)?

The coding is beyond me (for now)

Daniel


"keepITcool" wrote:

Daniel,

I'm not sure if following will work for the autosave addin
but i'd give it a try...

double click the autosave project in vbe.

Use following hint to answer the prompt:
What name do South Africans use for CONNOCHAETES TAURINUS?

(1st letter uppercase, add 2 exclamation marks)

somewhat surprising in relation to their views on public licensing..

cryptic? sure! <VBG


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


?B?RGFuaWVs?= wrote:

Good morning,

I changed the settings of the autosave add-in (do not prompt before
save etc) but whenever i close excel and load it again it always
reset the settings to default values. Is there a way to retain my
settings as the new default values? Or is the some coding I can
use to automatically reset the values instead of manually having to
do it.

Thank you

Daniel

autosave add-in settings
 

ave maria... s'th got lost...

type thisworkbook.sAVE


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


keepITcool wrote:

In the Project Explorer select Autosave.xla
In the Immediate Pane type thisworkbook.s

Done.

autosave add-in settings
 

Sorry to bother you again, but I've tried what you suggested and it just doesn't seem to work (for me at least). I set the settings the way I want them. then I select the Autosave.xla and in the immediate window entered thisworkbook.save and pressed enter.

am I missing something?

could you run through it one more time.

Thank you for the help.

Daniel

"keepITcool" wrote:

ave maria... s'th got lost...

type thisworkbook.sAVE


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


keepITcool wrote:

In the Project Explorer select Autosave.xla
In the Immediate Pane type thisworkbook.s

Done.

autosave add-in settings
 

have you tried it the hard way as well
(see description in earlier post?)

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


?B?RGFuaWVs?= wrote:

Sorry to bother you again, but I've tried what you suggested and it
just doesn't seem to work (for me at least). I set the settings the
way I want them. then I select the Autosave.xla and in the immediate
window entered thisworkbook.save and pressed enter.

am I missing something?

could you run through it one more time.

Thank you for the help.

Daniel