Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
2003 - putting VBA code into another .XLS file?
Message
From
18/09/2006 15:32:15
 
 
To
All
General information
Forum:
Microsoft Office
Category:
Excel
Title:
2003 - putting VBA code into another .XLS file?
Miscellaneous
Thread ID:
01154890
Message ID:
01154890
Views:
52
I've got some code that does something for me, added through the VBA Editor feature while in an Excel workbook.

I now want to use that code in another worksheet. Knowing NOTHING about how these things *should* be done, I observed an "Export" option in the VBA editor. So I used it, and it created a file for me (.CLS).

I then opened up the xls file where I wanted to use that code, opened the VBA Editor and used "IMPORT" and it seemed to run OK.
BUT there's no sign of the code in the new worksheet.

Can someone advise how I should properly do what I am trying to do?
Thanks
Next
Reply
Map
View

Click here to load this message in the networking platform