Re-use of macro's

[Maarten]

Hi,

In my Excel sheet I programmed a macro, and I must say it works fine ..

But, how to apply that same macro in another spread sheets, for executing the same steps.

In my first sheet I exported the macro, and then I imported the macro in my second sheet, but it did
not work.

Must the file be saved as file type *.cls or what ???

Some help would be nice.

 

[Charles Kenyon]

You need to ask this in a newsgroup about programming Excel. This one is
about Word.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide




--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

 

[Tony Jollans]

Charles is correct - you should ask in an Excel group, but if you want to
use the macro in multiple workbooks it should probably be in your
Personal.xls file. Wherever you put it, exporting and importing should be
straightforward; if you use the popup menu options you shouldn't need to
worry about the file extensions, they will be correct by default. As for why
the macro didn't work, I can only guess; I would post it in an Excel group
and let the Excel experts take a look.