DonationCoder.com Software > Finished Programs

DONE: Utility: Convert Multiple Columns in Excel to a Single Column

<< < (6/6)

Perry Mowbray:
It would be interesting to know how you go... I've got lots of Excel and Word toolbars around the building and we're looking at upgrading shortly...-Perry Mowbray (January 10, 2011, 11:19 PM)
--- End quote ---

I only have the one, but it's used all over the country.  If and when I do something about it I'll let you know 8)

FYI you're old toolbars will still showup, just not like they used to (they appear under the ADDINS tab of the ribbon, and they can be attached to the quick launch bar)

I have mixed feelings about the 'upgrade' - there are good things (substantially larger worksheets for one), but the interface changes are so drastic that my productivity took a huge hit (this has been discussed elsewhere).  Even 2 months on I still have to go searching for things I used to use all the time
-Target (January 11, 2011, 12:24 AM)
--- End quote ---

Thanks.

Yes I'm concerned not just for my loss of productivity, but the drain on my time sorting everyone else out...

Target:
It would be interesting to know how you go... I've got lots of Excel and Word toolbars around the building and we're looking at upgrading shortly...-Perry Mowbray (January 10, 2011, 11:19 PM)
--- End quote ---
I only have the one, but it's used all over the country.  If and when I do something about it I'll let you know 8)-Target (January 11, 2011, 12:24 AM)
--- End quote ---

Turns out the ribbon is easier to work with than I expected - had some downtime on Friday because of a systems outage so I spent some time on this

As usual the VBA help file is, well, less than helpful.  The info may be there, but I clearly don't know the right questions to ask.

A google search turned up several references but this one did the trick. 

Everythings in XML, and while I won't pretend that I know anything about XML structure or syntax, the structure as used is pretty straight foward. 

Greatest aid is the Custom UI Editor for MS Office (get it here).  It will generate sample code, includes a code validator, and will generate the necessary VBA stubs for you (you need to copy and paste into the editor if you're going to use them).  That last bit is worth noting - it took me a while to twig to the fact that there is a parameter you need to add to the called routines to make the buttons work properly.

No doubt there's more to the whole ribbon interface, but I only needed to get a new tab on the bar for my macro's so that's as far as I've taken it (but YMMV)

Renegade:
As usual the VBA help file is, well, less than helpful.  The info may be there, but I clearly don't know the right questions to ask.
-Target (January 16, 2011, 06:28 PM)
--- End quote ---

I really don't understand why MS doesn't get .NET into MS Office already. You can use it in SQL Server, so why not Office? VBA is, well, painful in comparison.

Target:
I really don't understand why MS doesn't get .NET into MS Office already. You can use it in SQL Server, so why not Office? VBA is, well, painful in comparison. -Renegade (January 16, 2011, 06:58 PM)
--- End quote ---

I couldn't comment on that one, though as with many things MS's reasoning defies most accepted forms of logic. 

VBA got me started on coding and I don't know C (in any variation).  From a user perspective .NET seems to be a significant piece of bloatware (who wants to download and install a huge - up 250M -  piece of extra software just so they can write or run a macro...)

That said I'm not averse to learning C, I just don't have a reason at the moment

Perry Mowbray:
Thanks for that  :Thmbsup: I'll have to keep this handy for future reference...

VBA's OK after you get used to it, and certainly quick to whip up something  ;)

Navigation

[0] Message Index

[*] Previous page