What is calling this?

[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

 

[Bob Phillips]

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?

It is run automaticaly when persoanl.xlsb is opened, which is done when
Excel starts.

2) How do I disable/unload it?

Why would you want to, it needs to setup these events at the start.

 

[Risky Dave]

Bob, to make myself clear (and in reverse order):

2) This functionality is not used by the business, so all it is doing is
getting in my way :-(

1) Yes, but how? I think I mean, has the Excel application code been
modified to call this functionality or is it something I can switch off via
my own code within a VBA module or some such?

Hope this clarifies,

Dave

 

[Joel]

You can delete it or rename the personal.xlsb file. Excel automatically
looks for this file whenever an excel file is opened. I would rename it
personal.xlsb.old just incase there is something that you really need in the
file you can recover it later.

 

[Risky Dave]

Joel,

Thanks.

How do I go about changing the name? Through the VBA environment I can see
the code associated with VBAProject (PERSONAL.XLSB) but cannot figure out how
to change the bracketed part - the Project Properties only let me change the
'VBAProject' text.

Dave

 

[Joel]

close excel and use you window Explorer. I'm not sure where the file is
located in Excel 2007 on the C: drive. Do a search on the C: drive for the
filename.