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