Global Macro
 

I am a programmer but have limited experience with Office Automation.
We need to somehow install a macro for groups of users at different
companies that will sort a spreadsheet based on a certain key
combination. This macro should be available to the users for any new
spreadsheet they create. It also needs to be easy for us to give them
the macro (send via e-mail...?).

* Is there a way to e-mail a macro that self-installs?
* Is there a way to install a macro globally for each company... so all
users at that company use the same macro (this is not a requirement...
if the e-mail option works)
* Is there a way to allow each company to choose a custom key
combination?

I have never used Excel macros.

Thanks,
Denise


--
dherne
------------------------------------------------------------------------
dherne's Profile: http://www.excelforum.com/member.php...o&userid=25067
View this thread: http://www.excelforum.com/showthread...hreadid=385859

Global Macro
 

VBA macros reside in Workbooks (or special workbooks called Addins)

The workbook or addin must be open in the users machine to run the macro.

Macros in an addin should be supported by creating a menu item to trigger
them.

--
Regards,
Tom Ogilvy

"dherne" wrote in
message ...

I am a programmer but have limited experience with Office Automation.
We need to somehow install a macro for groups of users at different
companies that will sort a spreadsheet based on a certain key
combination. This macro should be available to the users for any new
spreadsheet they create. It also needs to be easy for us to give them
the macro (send via e-mail...?).

* Is there a way to e-mail a macro that self-installs?
* Is there a way to install a macro globally for each company... so all
users at that company use the same macro (this is not a requirement...
if the e-mail option works)
* Is there a way to allow each company to choose a custom key
combination?

I have never used Excel macros.

Thanks,
Denise


--
dherne
------------------------------------------------------------------------
dherne's Profile:
http://www.excelforum.com/member.php...o&userid=25067
View this thread: http://www.excelforum.com/showthread...hreadid=385859

Global Macro
 

dherne,

* Is there a way to e-mail a macro that self-installs?
Yes, but any company worth it's salts will have antivirus software which
will prevent the macro installing.
This is how malicious software (viruses/virii) is propagated!

* Is there a way to install a macro globally for each company... so all
users at that company use the same macro (this is not a requirement...
if the e-mail option works)

If their copy of Excel is on a server, then one installation on the server
will appear in every user's Excel, when they open it.

* Is there a way to allow each company to choose a custom key
combination?

Yes, if you write the macro in such a way as to allow the company's system
manager (password protected) to access the code and change the
combination(s).

Henry


"dherne" wrote in
message ...

I am a programmer but have limited experience with Office Automation.
We need to somehow install a macro for groups of users at different
companies that will sort a spreadsheet based on a certain key
combination. This macro should be available to the users for any new
spreadsheet they create. It also needs to be easy for us to give them
the macro (send via e-mail...?).

* Is there a way to e-mail a macro that self-installs?
* Is there a way to install a macro globally for each company... so all
users at that company use the same macro (this is not a requirement...
if the e-mail option works)
* Is there a way to allow each company to choose a custom key
combination?

I have never used Excel macros.

Thanks,
Denise


--
dherne
------------------------------------------------------------------------
dherne's Profile:
http://www.excelforum.com/member.php...o&userid=25067
View this thread: http://www.excelforum.com/showthread...hreadid=385859

Global Macro
 

Thanks, but can you please give me more inforamtion. Is it possible to
have some sort of 'global' macro that will work, even if they create a
new spreadsheet from scratch? If so, how?

For example, if I choose Ctrl-Alt-S to do my custom sorting macro, is
there a way to make it work for all future spreadsheets that are
created?

How can I automatically install this macro for the user?

Thanks,
Deise


--
dherne
------------------------------------------------------------------------
dherne's Profile: http://www.excelforum.com/member.php...o&userid=25067
View this thread: http://www.excelforum.com/showthread...hreadid=385859

Global Macro
 

Write the code in a workbook.xls
than save it as workbook.xla

This is an add-in

--
steveB

Remove "AYN" from email to respond
"dherne" wrote in
message ...

Thanks, but can you please give me more inforamtion. Is it possible to
have some sort of 'global' macro that will work, even if they create a
new spreadsheet from scratch? If so, how?

For example, if I choose Ctrl-Alt-S to do my custom sorting macro, is
there a way to make it work for all future spreadsheets that are
created?

How can I automatically install this macro for the user?

Thanks,
Deise


--
dherne
------------------------------------------------------------------------
dherne's Profile:
http://www.excelforum.com/member.php...o&userid=25067
View this thread: http://www.excelforum.com/showthread...hreadid=385859

Global Macro
 

Just to add to Steve's contribution:

http://www.microsoft.com/officedev/index/apps.htm
Distributing Microsoft Excel 97, Word 97, and PowerPoint 97 Solutions (March
3, 1997)

http://www.microsoft.com/exceldev/tips/addins.htm
Protecting the Code in an Add-in


http://msdn.microsoft.com/library/en.../xlcraddns.asp
Creating Add-ins in Microsoft Excel 97

http://support.microsoft.com/?id=167909
XL: Securing Visual Basic Code in Microsoft Excel

http://support.microsoft.com/?id=156942
XL97: How to Create an Add-in File in Microsoft Excel 97

While some where written around the Office 97 timeframe, they are still
applicable for regular addins.

--
Regards,
Tom Ogilvy


"dherne" wrote in
message ...

Thanks, but can you please give me more inforamtion. Is it possible to
have some sort of 'global' macro that will work, even if they create a
new spreadsheet from scratch? If so, how?

For example, if I choose Ctrl-Alt-S to do my custom sorting macro, is
there a way to make it work for all future spreadsheets that are
created?

How can I automatically install this macro for the user?

Thanks,
Deise


--
dherne
------------------------------------------------------------------------
dherne's Profile:
http://www.excelforum.com/member.php...o&userid=25067
View this thread: http://www.excelforum.com/showthread...hreadid=385859

Global Macro
 

Tom,

Your comment is special to me - Thank you!

--
steveB

Remove "AYN" from email to respond
"Tom Ogilvy" wrote in message
...
Just to add to Steve's contribution:

http://www.microsoft.com/officedev/index/apps.htm
Distributing Microsoft Excel 97, Word 97, and PowerPoint 97 Solutions
(March
3, 1997)

http://www.microsoft.com/exceldev/tips/addins.htm
Protecting the Code in an Add-in


http://msdn.microsoft.com/library/en.../xlcraddns.asp
Creating Add-ins in Microsoft Excel 97

http://support.microsoft.com/?id=167909
XL: Securing Visual Basic Code in Microsoft Excel

http://support.microsoft.com/?id=156942
XL97: How to Create an Add-in File in Microsoft Excel 97

While some where written around the Office 97 timeframe, they are still
applicable for regular addins.

--
Regards,
Tom Ogilvy


"dherne" wrote in
message ...

Thanks, but can you please give me more inforamtion. Is it possible to
have some sort of 'global' macro that will work, even if they create a
new spreadsheet from scratch? If so, how?

For example, if I choose Ctrl-Alt-S to do my custom sorting macro, is
there a way to make it work for all future spreadsheets that are
created?

How can I automatically install this macro for the user?

Thanks,
Deise


--
dherne
------------------------------------------------------------------------
dherne's Profile:
http://www.excelforum.com/member.php...o&userid=25067
View this thread:
http://www.excelforum.com/showthread...hreadid=385859