General information
Title:
2003 - putting VBA code into another .XLS file?
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only