macro without workbook

Hi,

I have found out that it's possible to do this:

I have a file (A) which contains a macro and looks like a regular xls file.
If I open this file (A) basically nothing (visible) happens.
If I then open another excel file (workbook B) the macro (A) will appear in a module in this opened workbook.

Could you tell me how can I create a macro without a workbook (like A)?

I tried to export the modul where the macro is saved but then it was not possible to open the exported module...

Thanks

I for one have no idea what you mean. It's not clear whether you are saying workshee & mening workbook.

All macros need to be contained in a workbook

Almost sounds like the first file is an addin.
Although the code does not normally appear in the list of available macros.

Or maybe the workbook makes itself invisble upon loading. What happens if you open the file and do not enable macros. Can you see it then?

You need to post the code, remember to use Code Tags

If the first file is an addin, will the macro run on that file?