Share VB Code

[watzmann]

Hi All ,

if i have a code working fine and i need to share it with a collegue who will not be familar with editing VB editor , he just want to run my code on his excel sheet ....

how to save it for him?.....i just found one extension i can get by exporting the code ".cls" , i think it will not help as i have tried and it faild .

do we have a solution here to share the code without copy/paste?

[teylyn]

You could save your file with the code as an .xla file and send it to him. He then would have to do Tools - Add ins - Browse to the file and install the add-in.

[royUK]

If it is only one macro & only needded in one workbook, you can export the module. Transfer the *.bas to the other machine then import the .bas into the new workbook.

In the original workbook's VB Editor right click on the module & choose Export. Note where it is exported to. Transfer the file to the other machine.

In the other workbook open the editor, click on the VBA Project & choose Import. Select he file & it will import

[watzmann]

I tried by exporting to cls file and i have tried to import it again with a new file but it goes automatically to "Class Modules "

originally it was a code written in "this workbook "

if i run it it doesn't work ,

[royUK]

Without seein your code it's hard to know what you are doing. Unless the code is actually a Class module it should export asa *.bas file.

[watzmann]

Please Login or Register  to view this content.

[Andy Pope]

Why is the code in the Thisworkbook object rather than a standard code module?

If in a standard code module it will import/export as .bas file.