which command?

[Martyn]

Hi,
which macro procedure command should be used in order to log that the
workbook is beeing opened without letting the user notice?
TIA

 

[Bob Phillips]

Martyn,

It depends what you mean by log, but I don't think you will find a command
to do it.

If you want to log a file being opened, you need to build the capability
yourself, and it wll depend where you want to log it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[sp00nix]

in addition to that, if the user is opening the file on the network, i
will ask them if they would like to open it with your macro. You ca
create a digit signature to sign your macros so that it doesnt ask, bu
still, the user needs to accept your signature at least once before
macro equiped workbook can be run without notice.
Mik

 

[Martyn]

Thanks both to Bob and sp00nix,
Just one follow-up question then...
Say I use Open file event for logging the accessed user, date, time that the
workbook is opened.
But since this can only be activated IF the user has enabled using of
macros, is there no alternative to log an excel file usage on a PC without
notice?

 

[Bob Phillips]

Martyn,

I can't see one.

There are a number of (limited) techniques to try and force the user to open
with macros enabled. The most common of these is to open up on a page that
has a message saying that you need macros, with all other sheets hidden
(very hidden). If macros are enabled, you can unhide these sheets and hide
the warning one.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Thanks both to Bob and sp00nix,
Just one follow-up question then...
Say I use Open file event for logging the accessed user, date, time that the
workbook is opened.
But since this can only be activated IF the user has enabled using of
macros, is there no alternative to log an excel file usage on a PC without
notice?

 

[Martyn]

Hi Bob,
I already know that technique. I am just wondering if there is an
alternative way.
Thank you anyway.

Martyn,

I can't see one.

There are a number of (limited) techniques to try and force the user to open
with macros enabled. The most common of these is to open up on a page that
has a message saying that you need macros, with all other sheets hidden
(very hidden). If macros are enabled, you can unhide these sheets and hide
the warning one.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)