ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Saving a variable value (https://www.excelbanter.com/excel-programming/376914-saving-variable-value.html)

Ed

Saving a variable value
 
I have the following macro set to run when I open a workbook.

AutoSaveDetected = AddIns("Autosave Add-in").Installed

I use this to determine if a user has auto save installed. If they do, I
disable it and then enable it again in a BeforeClose procedure.

I have a problem in that if I disable auto save, I think the variable result
changes so that the value ends up as being always false when I run the
BeforeClose procedure and auto save never gets enabled.

Is there a way to have the variable store the value when the workbook is
opened instead of the current value?


Bob Phillips

Saving a variable value
 
Why not just disable it within the BeforeClose event as well. Put it in an
On Error Resume Next, and it won't matter if it is already disabled.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ed" wrote in message
...
I have the following macro set to run when I open a workbook.

AutoSaveDetected = AddIns("Autosave Add-in").Installed

I use this to determine if a user has auto save installed. If they do, I
disable it and then enable it again in a BeforeClose procedure.

I have a problem in that if I disable auto save, I think the variable

result
changes so that the value ends up as being always false when I run the
BeforeClose procedure and auto save never gets enabled.

Is there a way to have the variable store the value when the workbook is
opened instead of the current value?




Ed

Saving a variable value
 
Hi Bob,

I'm just starting out with VBA.

Could you explain what this procedure does?

thanks

"Bob Phillips" wrote:

Why not just disable it within the BeforeClose event as well. Put it in an
On Error Resume Next, and it won't matter if it is already disabled.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ed" wrote in message
...
I have the following macro set to run when I open a workbook.

AutoSaveDetected = AddIns("Autosave Add-in").Installed

I use this to determine if a user has auto save installed. If they do, I
disable it and then enable it again in a BeforeClose procedure.

I have a problem in that if I disable auto save, I think the variable

result
changes so that the value ends up as being always false when I run the
BeforeClose procedure and auto save never gets enabled.

Is there a way to have the variable store the value when the workbook is
opened instead of the current value?





Bob Phillips

Saving a variable value
 
Private Sub Workbook_BeforeClose(Cancel As Boolean)
On Error Resume Next
'your code to disable the addin
On Error GoTo 0

'your code to enable it
End Sub



--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ed" wrote in message
...
Hi Bob,

I'm just starting out with VBA.

Could you explain what this procedure does?

thanks

"Bob Phillips" wrote:

Why not just disable it within the BeforeClose event as well. Put it in

an
On Error Resume Next, and it won't matter if it is already disabled.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ed" wrote in message
...
I have the following macro set to run when I open a workbook.

AutoSaveDetected = AddIns("Autosave Add-in").Installed

I use this to determine if a user has auto save installed. If they

do, I
disable it and then enable it again in a BeforeClose procedure.

I have a problem in that if I disable auto save, I think the variable

result
changes so that the value ends up as being always false when I run the
BeforeClose procedure and auto save never gets enabled.

Is there a way to have the variable store the value when the workbook

is
opened instead of the current value?








All times are GMT +1. The time now is 01:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com