R
Risky Dave
Hi,
I am developing an XL application for use on my business system and have hit
a problem that I don't understand (I'm not a programmer, the little I know is
all self-taught).
When XL runs, a VBA Project called Personal.xlsb (this is Office '07 under
Vista Enterprise) kicks in. This code has been written at some point in the
past by the business and is meant to do some automated docuement management
(ie. ensures a new document is registered, contrls where and how saves are
done etc).
The person responsible for producing this code was a contractor who is no
longer with us and no-one else seems to understand what it does. I realise
that this is a problem for my business and I can get this resolved, so
please, no comments on the rubbish way we have done this
My issue is that my application has some code that controls what the file is
called when it closes and where it is put on the corporate networks. It does
this automatically when the 'X' is selected or when an Exit button is
clicked. I need this functionality to provide quality control around how my
users name the file and some other housekeeping. Inevitably, my code
conflicts with the code in Personal.xlsb.
The programmer's comment in Sub Workbook_Open() of Personal.xlsb within the
'This Workbook' Object states that ' This function is called whenever the
personal.xls file is opened which should be every time Excel is opened.It
simply initialises the EventClass so that further events can be caught'
So:
1) What is calling the personal.xlsb as well as my own code?
2) How do I disable/unload it?
My apologies for the length of this posting. Hppy to provide further details
as needed.
I do have the express permission of my business owners to be doing this!
TIA
Dave
I am developing an XL application for use on my business system and have hit
a problem that I don't understand (I'm not a programmer, the little I know is
all self-taught).
When XL runs, a VBA Project called Personal.xlsb (this is Office '07 under
Vista Enterprise) kicks in. This code has been written at some point in the
past by the business and is meant to do some automated docuement management
(ie. ensures a new document is registered, contrls where and how saves are
done etc).
The person responsible for producing this code was a contractor who is no
longer with us and no-one else seems to understand what it does. I realise
that this is a problem for my business and I can get this resolved, so
please, no comments on the rubbish way we have done this
My issue is that my application has some code that controls what the file is
called when it closes and where it is put on the corporate networks. It does
this automatically when the 'X' is selected or when an Exit button is
clicked. I need this functionality to provide quality control around how my
users name the file and some other housekeeping. Inevitably, my code
conflicts with the code in Personal.xlsb.
The programmer's comment in Sub Workbook_Open() of Personal.xlsb within the
'This Workbook' Object states that ' This function is called whenever the
personal.xls file is opened which should be every time Excel is opened.It
simply initialises the EventClass so that further events can be caught'
So:
1) What is calling the personal.xlsb as well as my own code?
2) How do I disable/unload it?
My apologies for the length of this posting. Hppy to provide further details
as needed.
I do have the express permission of my business owners to be doing this!
TIA
Dave