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

"Risky Dave" <(E-Mail Removed)> wrote in message
news:E60FA566-2625-4C96-8416-(E-Mail Removed)...
> 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.


> 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, 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


< snipped by Dave>


> >
> > 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.
>
>
> > 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
>
>
>

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" wrote:

> 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
>
>
> < snipped by Dave>
>
>
> > >
> > > 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.
> >
> >
> > > 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
> >
> >
> >

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" wrote:

> 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" wrote:
>
> > 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
> >
> >
> > < snipped by Dave>
> >
> >
> > > >
> > > > 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.
> > >
> > >
> > > > 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
> > >
> > >
> > >

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.

"Risky Dave" wrote:

> 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" wrote:
>
> > 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" wrote:
> >
> > > 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
> > >
> > >
> > > < snipped by Dave>
> > >
> > >
> > > > >
> > > > > 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.
> > > >
> > > >
> > > > > 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
> > > >
> > > >
> > > >