Professional Excel Development 2nd Edition

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
I love the way when you open up that link, it says that that book is frequently bought with Excel VBA Programming For Dummies (that's what it tells me, anyway). errrr.... some people clearly don't do their research. :eeek:

So I guess that means customers are buying the Programming for Dummies and preordering the PED v2 at the same time. At least they have a couple of months to get up to speed! :rofl:



I'll be very interested to hear your reviews on it when you have your copies.
 
Colin_L said:
I love the way when you open up that link, it says that that book is frequently bought with Excel VBA Programming For Dummies (that's what it tells me, anyway). errrr.... some people clearly don't do their research. :eeek:

So I guess that means customers are buying the Programming for Dummies and preordering the PED v2 at the same time. At least they have a couple of months to get up to speed! :rofl:
Click to expand...

Rory made exactly the same point ;-)

I guess the buyers are all "the glass is half full" optimists!

I wonder how much ribbon UI will be in the book (I still haven't touched anything to do with ribbon programming, and until work installs anything with the ribbon there's just no need). Also looking forward to their analysis of .NET programming with Excel.
 
RichardSchollar said:
Rory made exactly the same point.

I wonder how much ribbon UI will be in the book (I still haven't touched anything to do with ribbon programming, and until work installs anything with the ribbon there's just no need). Also looking forward to their analysis of .NET programming with Excel.
Click to expand...
He did!? Well, you know what they say about great minds. :rofl:

I confess I've hardly touched the ribbon either. Simple fact is that I use Excel 07 at home, but at work we use 02 and 03 and I can't see an upgrade coming anytime soon. In fact, I'd be willing to bet money that the next version of Excel will be released before a work upgrade. Until my hand is forced and using 07 becomes more than a "hobby", I can't see myself getting involved in something as scary as a ribbon.
 
Colin_L said:
I love the way when you open up that link, it says that that book is frequently bought with Excel VBA Programming For Dummies (that's what it tells me, anyway). errrr.... some people clearly don't do their research. :eeek:

So I guess that means customers are buying the Programming for Dummies and preordering the PED v2 at the same time. At least they have a couple of months to get up to speed! :rofl:
Click to expand...

It is funny that you should mention that, but I was with a client this week who had done just that, their two VBA books were PED and Dummies. Needless to say, they didn't understand PED.
 
RichardSchollar said:
I wonder how much ribbon UI will be in the book (I still haven't touched anything to do with ribbon programming, and until work installs anything with the ribbon there's just no need). Also looking forward to their analysis of .NET programming with Excel.
Click to expand...

The ribbon isn't that scary, just hard work <g>. Ken has a pretty comprehensive, if rather dry, book on it.

If you want that, you should take a look at Ty Anderson's Apress book Professional Office 2007 Development With VSTO,
 
xld said:
The ribbon isn't that scary, just hard work <g>. Ken has a pretty comprehensive, if rather dry, book on it.

If you want that, you should take a look at Ty Anderson's Apress book Professional Office 2007 Development With VSTO,
Click to expand...

An Access MVP recommended The IDBE Ribbon Creator, available as shareware. It looks like it takes a lot of the XML drudgery out of building ribbons.

Denis

</g>
 
RichardSchollar said:
...I still haven't touched anything to do with ribbon programming, and until work installs anything with the ribbon there's just no need. Also looking forward to their analysis of .NET programming with Excel.
Click to expand...

Colin_L said:
I confess I've hardly touched the ribbon either. Simple fact is that I use Excel 07 at home, but at work we use 02 and 03 and I can't see an upgrade coming anytime soon. In fact, I'd be willing to bet money that the next version of Excel will be released before a work upgrade. Until my hand is forced and using 07 becomes more than a "hobby", I can't see myself getting involved in something as scary as a ribbon.
Click to expand...

Yup, pretty much the same for me. I've tinkered a bit at home and created one add-in that I now use at work that added a button on the ribbon. But until there's a gun to my head, getting adept at customizing the ribbon is just not going to get enough traction to work its way up my priority list. And I don't see my employer upgrading any time soon. Indeed, it would not surprise in the least if they skip Office 12 completely and eventually just move to Office 14 in a couple of years. Likewise, we're still on XP. I expect Vista will also get jumped over.

PED2, however will most definitely *NOT* get jumped over when it comes to me. I'll be preordering that baby here shortly. Gonna be Christmas in May, baby! :biggrin:
 
You must log in or register to reply here.

Forum statistics

Threads
1,225,375
Messages
6,184,610
Members
453,247
Latest member
scouterjames

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top