3 possible ways.

1) Using the Add_in manager under the Tools menu
2) saving a file in the default xlstart folder
3) saving the file under the alternative xlstart folder

each of these can easily be checked...

theer is another way, but its more complex and is for
using component objects - and I suspect a bit techy for
this answer.

As a default, there's a file called Personal.xls in the
xlstart foldeer where you can save your code. This file
is hidden when opened in Excel...look under the Windows
menu. If there is a hidden file the unhide menu item will
be enabled.


HTH

Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
Hi

When I open an Excel file, some "add-in" is downloaded
and installed in my
excel file. (Please reference to the pic.)
I want to know how they do that and where can I find
those downloaded
materials in my computer?(I want to change some coding
in it).

Thank you
!

1) There is no Add_in
2) & 3) no file in xlstart folder ( under my profile or in program files\MS
office dir)

there is no "hided" file too......

Thus, I guess it is written in component object, is there any way to check
if it exist?
Thank you

!



"Patrick Molloy" <xl_expert@xxxhotmail wrote in message
...
3 possible ways.

1) Using the Add_in manager under the Tools menu
2) saving a file in the default xlstart folder
3) saving the file under the alternative xlstart folder

each of these can easily be checked...

theer is another way, but its more complex and is for
using component objects - and I suspect a bit techy for
this answer.

As a default, there's a file called Personal.xls in the
xlstart foldeer where you can save your code. This file
is hidden when opened in Excel...look under the Windows
menu. If there is a hidden file the unhide menu item will
be enabled.


HTH

Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
Hi

When I open an Excel file, some "add-in" is downloaded
and installed in my
excel file. (Please reference to the pic.)
I want to know how they do that and where can I find
those downloaded
materials in my computer?(I want to change some coding
in it).

Thank you
!

open the IDE (Alt & F11)
Look in the project viewer...there's one project for the
book you're in
eg

VBAProject(Book1)

if there are certain types of ad-in they may appear as
well. If not, look in the onject browser (F2) and under
Tools/references


-----Original Message-----
1) There is no Add_in
2) & 3) no file in xlstart folder ( under my profile or
in program files\MS
office dir)

there is no "hided" file too......

Thus, I guess it is written in component object, is
there any way to check
if it exist?
Thank you

!



"Patrick Molloy" <xl_expert@xxxhotmail wrote in message
...
3 possible ways.

1) Using the Add_in manager under the Tools menu
2) saving a file in the default xlstart folder
3) saving the file under the alternative xlstart folder

each of these can easily be checked...

theer is another way, but its more complex and is for
using component objects - and I suspect a bit techy for
this answer.

As a default, there's a file called Personal.xls in the
xlstart foldeer where you can save your code. This file
is hidden when opened in Excel...look under the Windows
menu. If there is a hidden file the unhide menu item
will
be enabled.


HTH

Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
Hi

When I open an Excel file, some "add-in" is
downloaded
and installed in my
excel file. (Please reference to the pic.)
I want to know how they do that and where can I find
those downloaded
materials in my computer?(I want to change some coding
in it).

Thank you
!





.

thank you
Here comes a new question.

I found that if I assign a marco to the self-created toolbar, it will
somehow record the location of the file automatically.
If I change the location of the workbook, the "pointer" will still point to
the old one and thus fail to execute the macro.

How can I change the setting of the macro?
..
Thanks



"Patrick Molloy" wrote in message
...
open the IDE (Alt & F11)
Look in the project viewer...there's one project for the
book you're in
eg

VBAProject(Book1)

if there are certain types of ad-in they may appear as
well. If not, look in the onject browser (F2) and under
Tools/references


-----Original Message-----
1) There is no Add_in
2) & 3) no file in xlstart folder ( under my profile or
in program files\MS
office dir)

there is no "hided" file too......

Thus, I guess it is written in component object, is
there any way to check
if it exist?
Thank you

!



"Patrick Molloy" <xl_expert@xxxhotmail wrote in message
...
3 possible ways.

1) Using the Add_in manager under the Tools menu
2) saving a file in the default xlstart folder
3) saving the file under the alternative xlstart folder

each of these can easily be checked...

theer is another way, but its more complex and is for
using component objects - and I suspect a bit techy for
this answer.

As a default, there's a file called Personal.xls in the
xlstart foldeer where you can save your code. This file
is hidden when opened in Excel...look under the Windows
menu. If there is a hidden file the unhide menu item
will
be enabled.


HTH

Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
Hi

When I open an Excel file, some "add-in" is
downloaded
and installed in my
excel file. (Please reference to the pic.)
I want to know how they do that and where can I find
those downloaded
materials in my computer?(I want to change some coding
in it).

Thank you
!





.

1. make the macro workbook an add-in, so that you are just passing the macro
name, not the book, or
2. create a custom toolbar and attach it to the workbook, so that when you
move the book, the toolbar moves with it, or
3. create the toolbar on the fly when you open the workbook in an auto_open
routine, or best,
4. a combination of 1 and 3.

Robin Hammond
www.enhanceddatasystems.com


"!" <!@!.! wrote in message ...
thank you
Here comes a new question.

I found that if I assign a marco to the self-created toolbar, it will
somehow record the location of the file automatically.
If I change the location of the workbook, the "pointer" will still point
to
the old one and thus fail to execute the macro.

How can I change the setting of the macro?
.
Thanks



"Patrick Molloy" wrote in message
...
open the IDE (Alt & F11)
Look in the project viewer...there's one project for the
book you're in
eg

VBAProject(Book1)

if there are certain types of ad-in they may appear as
well. If not, look in the onject browser (F2) and under
Tools/references


-----Original Message-----
1) There is no Add_in
2) & 3) no file in xlstart folder ( under my profile or
in program files\MS
office dir)

there is no "hided" file too......

Thus, I guess it is written in component object, is
there any way to check
if it exist?
Thank you

!



"Patrick Molloy" <xl_expert@xxxhotmail wrote in message
...
3 possible ways.

1) Using the Add_in manager under the Tools menu
2) saving a file in the default xlstart folder
3) saving the file under the alternative xlstart folder

each of these can easily be checked...

theer is another way, but its more complex and is for
using component objects - and I suspect a bit techy for
this answer.

As a default, there's a file called Personal.xls in the
xlstart foldeer where you can save your code. This file
is hidden when opened in Excel...look under the Windows
menu. If there is a hidden file the unhide menu item
will
be enabled.


HTH

Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
Hi

When I open an Excel file, some "add-in" is
downloaded
and installed in my
excel file. (Please reference to the pic.)
I want to know how they do that and where can I find
those downloaded
materials in my computer?(I want to change some coding
in it).

Thank you
!





.