New VBA Project

[alk1000]

Hi Everyone,

I’m writing a new project in VBA to manipulate workbooks and create reports based on information saved in multiple workbooks.

I was wondering about the best way to pass the code to the client. Shall I save it as an .xla file, or shall I keep it in xls format or is there a better way.

As you notice it’s the first time I face this issue. I always wrote simple subroutines for friends which I didn’t care much how to protect and what the best way to publish


Thanks,
Daniel

 

[Oorang]

Either can work, but for my preference I would do such a thing in an add-in (*.xla) that way the options I make would be always available whenever I wanted them.