View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Finister Mike Finister is offline
external usenet poster
 
Posts: 1
Default Creating a Toolbar to add-in

Hi there

I'm doing some VBA work on a spreadsheet and have got the code to read
through, validate and reformat. Now I want to do the following:

a) Write out the data as a text file (can use open etc. so no issues)
b) Have a new toolbar for the macro to run from (OK pretty easy I suppose)

However, I've seen something at my work where someone wrote something with a
..xla extension and double clicking on this meant that it auto-added the
toolbar into Excel and the object seemed to include macro stuff.

Is this done with VB6 and the Office SDK?

I'm also a VB programmer, but never turned my hand to do too much VBA
programming...only the simple stuff.

Any pointers would be great!

Thanks

Mike