importing a macro

[tabir]

Hi,
I'd like to save my xls file in a xml format.
This way doesn't save the macroes of the file.
Is there a way to import a macro?
If so how can I make it automatically?

The purpose is to save xls file in a text format.


Tal.

 

[Quandan - Marcel Kreijne]

Tal,

You can export the macro's in a workbook in .bas files, which you can
import into other files, but I really wonder why you would want to
strip the macro's first to add them to the file again later...

Maybe you could place the macro you need in an add-in, so you can
have the add-in installed in Excel and have the macro available in
all files?

Kind regards,

Marcel Kreijne
Quandan - Steunpunt voor spreadsheetgebruikers
(Quandan - dutch supportsite for spreadsheetusers)
www.quandan.nl