PDA

View Full Version : Creating an addin and posting to other PCs



lynnnow
10-04-2005, 04:06 AM
Hi,

I've created an addin that searches the entire workbook for a given string. It works perfectly on my pc. However, the problem is that when I copied it to another pc for testing, the xls file that I created the macro in was getting referenced and it just failed to show the menu item that I had created in the xla and also the macro doesn't show in the run macro dialog box to run it manually.

I've attached the xla for you guys to look at and tell me where i've gone and done something wrong.

Any pointers will be appreciated.

Thanks and regards,

Lynnnow

Dave
10-04-2005, 05:41 AM
You need to add a workbook open event to the XLA that shows your userform. Dave

lynnnow
10-04-2005, 09:25 PM
Hi Dave,

Does the workbook open event have to be in the addin that references the xls file or how. A little more clarification on this point would be helpful.

Thanks and regards,

Lynnnow

Dave
10-04-2005, 10:48 PM
Paste this in your workbook code. Dave

Private Sub Workbook_Open()
Call Search_All
End Sub


edit(x2): paste in XLA and save then re-open

mdmackillop
10-06-2005, 05:37 AM
Hi Lynnnow,
Just for your info, I created this KB ( http://vbaexpress.com/kb/getarticle.php?kb_id=195 ) to search and return all instances of a string. There is an XLA version in for approval at the moment, with a little more functionality if this is of any interest.
Regards
MD