Hi All;

I have some standard funcations written to one worksheet in module.

I want that function to be used in any worksheet I open with excell.

Can I add them as dll or module to standard.

IF yes then how? -

Thank you in advance.

Jack

Check out this site:

http://www.rondebruin.nl/personal.htm





"Jack" wrote:

Hi All;

I have some standard funcations written to one worksheet in module.

I want that function to be used in any worksheet I open with excell.

Can I add them as dll or module to standard.

IF yes then how? -

Thank you in advance.

Jack

Awsome

Thank's JLGWhiz - I will try this out and update.

"JLGWhiz" wrote in message
...
Check out this site:

http://www.rondebruin.nl/personal.htm





"Jack" wrote:

Hi All;

I have some standard funcations written to one worksheet in module.

I want that function to be used in any worksheet I open with excell.

Can I add them as dll or module to standard.

IF yes then how? -

Thank you in advance.

Jack

Awsome

Thank you JLGWhiz - I will try and update

"JLGWhiz" wrote in message
...
Check out this site:

http://www.rondebruin.nl/personal.htm





"Jack" wrote:

Hi All;

I have some standard funcations written to one worksheet in module.

I want that function to be used in any worksheet I open with excell.

Can I add them as dll or module to standard.

IF yes then how? -

Thank you in advance.

Jack

Hi There;

I tried but I am not able to add the file into references.

Please help.

Thank you,
Jack



"Jack" wrote in message
...
Awsome

Thank's JLGWhiz - I will try this out and update.

"JLGWhiz" wrote in message
...
Check out this site:

http://www.rondebruin.nl/personal.htm





"Jack" wrote:

Hi All;

I have some standard funcations written to one worksheet in module.

I want that function to be used in any worksheet I open with excell.

Can I add them as dll or module to standard.

IF yes then how? -

Thank you in advance.

Jack

What do you mean by add the file into references? As I understand the use of
the Personal.xls, it goes into the ExcelStart folder so that it is opened
automatically when Excel starts up. I don't know about adding anything into
references. If you are referring to Add-Ins, then that is a totally
different ballgame.

"Jack" wrote:

Hi There;

I tried but I am not able to add the file into references.

Please help.

Thank you,
Jack



"Jack" wrote in message
...
Awsome

Thank's JLGWhiz - I will try this out and update.

"JLGWhiz" wrote in message
...
Check out this site:

http://www.rondebruin.nl/personal.htm





"Jack" wrote:

Hi All;

I have some standard funcations written to one worksheet in module.

I want that function to be used in any worksheet I open with excell.

Can I add them as dll or module to standard.

IF yes then how? -

Thank you in advance.

Jack

Hi

My expection was creating a class or class module with standard procedure
and
addthem to tools - references and refere them when ever req. in any excel
files.

I might need to create dll or what.

and How I can refer this files in excel as library.

Thank you very for your help, apriciated.

Jack
"JLGWhiz" wrote in message
...
What do you mean by add the file into references? As I understand the use
of
the Personal.xls, it goes into the ExcelStart folder so that it is opened
automatically when Excel starts up. I don't know about adding anything
into
references. If you are referring to Add-Ins, then that is a totally
different ballgame.

"Jack" wrote:

Hi There;

I tried but I am not able to add the file into references.

Please help.

Thank you,
Jack



"Jack" wrote in message
...
Awsome

Thank's JLGWhiz - I will try this out and update.

"JLGWhiz" wrote in message
...
Check out this site:

http://www.rondebruin.nl/personal.htm





"Jack" wrote:

Hi All;

I have some standard funcations written to one worksheet in module.

I want that function to be used in any worksheet I open with excell.

Can I add them as dll or module to standard.

IF yes then how? -

Thank you in advance.

Jack

maybe this site will help.

http://www.ozgrid.com/VBA/excel-add-in-create.htm

"Jack" wrote:

Hi

My expection was creating a class or class module with standard procedure
and
addthem to tools - references and refere them when ever req. in any excel
files.

I might need to create dll or what.

and How I can refer this files in excel as library.

Thank you very for your help, apriciated.

Jack
"JLGWhiz" wrote in message
...
What do you mean by add the file into references? As I understand the use
of
the Personal.xls, it goes into the ExcelStart folder so that it is opened
automatically when Excel starts up. I don't know about adding anything
into
references. If you are referring to Add-Ins, then that is a totally
different ballgame.

"Jack" wrote:

Hi There;

I tried but I am not able to add the file into references.

Please help.

Thank you,
Jack



"Jack" wrote in message
...
Awsome

Thank's JLGWhiz - I will try this out and update.

"JLGWhiz" wrote in message
...
Check out this site:

http://www.rondebruin.nl/personal.htm





"Jack" wrote:

Hi All;

I have some standard funcations written to one worksheet in module.

I want that function to be used in any worksheet I open with excell.

Can I add them as dll or module to standard.

IF yes then how? -

Thank you in advance.

Jack