Question

Excel Experts-Exchange Regulars--Take 6

Asked by: byundt

As "Excel Experts-Exchange Regulars--Take 5" is getting quite long, here is a newer question for it.

This thread will be kept open indefinitely so the regulars in the Excel Zone can ask for assistance in other questions, share news and discoveries, ponder the mysteries of the ribbon, or discuss whether Stalin would really have risked World War III had he known that Excel's linear programming capability could organize logistics so decisively during the Berlin Airlift of 1948.

Previous threads:
http:Q_21890134.html
http:Q_22006939.html
http:Q_22157604.html
http:Q_22567885.html
http:Q_23025252.html

Previous Expert Discussion: http:Q_23025252.html

Next Expert Discussion: http:Q_23885760.html

This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

  • Plus...
  • 30 Day FREE access, no risk, no obligation
  • Collaborate with the world's top tech experts
  • Unlimited access to our exclusive solution database
  • Never be left without tech help again

Subscribe Now

Asked On
2008-04-19 at 14:31:59ID23337067
Topic

Microsoft Excel Spreadsheet Software

Participating Experts
11
Points
0
Comments
244

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

  • "The time we save is the biggest benefit of Experts Exchange to Warner Bros. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange." Mike Kapnisakis, Warner Bros.
  • "Our team likes having a resource that is more secure than just using Google and most experts using this service really know their stuff. It's nice to look here first versus using Google." Dayna Sellner, Lockheed Martin
  • "Anytime that I've been stumped with a problem, 9 out of 10 times Experts Exchange has either the accepted solution or an open discussion of the potential solution to the problem." Kenny Red, eBay Inc.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.

Screenshot of Experts Exchange Knowledgebase

Need individual assistance?

Our experts are ready to help.

If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.

Screenshot of Experts Exchange Knowledgebase

Want to learn from the best?

Read articles from industry experts.

Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.

Screenshot of an Article

Working on a long term project?

Store your work and research.

Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.

Screenshot of Experts Exchange Knowledgebase

Access the answers to your technology questions today.

Subscribe Now

30-day free trial. Register in 60 seconds.

What Makes Experts Exchange Unique?

Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Trusted by the world's most respected brands.

image of each brand's logo

Faithfully serving IT professionals since 1996.

Experts Exchange Logo

Try it out and discover for yourself.

Subscribe Now

30-day free trial. Register in 60 seconds.

Related Solutions

  1. JAR / WAR / EAR
    What is WAR and EAR ? What's the difference between Jar, War and Ear ?
  2. Linear Interpolation
    Does anyone have any experience with linear interpolation in Access?? I'll outline what I'm trying to achieve. Say I have a query called qrySQIntpol that returns the following; PLOT,AGE,SQ S2030442C0,9,2.85 S2030442C0,13,3.46 S2030442C0,17,3.35 S2030442C0,23,3.33 S2030442C0,...
  3. Excel Experts-Exchange Regulars
    Continuation to http://www.experts-exchange.com/Applications/MS_Office/Excel/Q_21743046.html This question is intended for discussion amongst the regulars in the Excel TA. It will alert them to matters of mutual interest in handling issues important to the TA. If you're a re...
  4. Excel Solver -- Non-Linear Programming challenge
    I have a spreadsheet that uses the Excel Solver-Add-In for linear/non-linear programming. My sample spreadsheet is stored at the following EE URL: http://www.ee-stuff.com/Expert/Upload/getFile.php?fid=2954 Purpose of the spreadsheet: - Determine the most central locatio...
  5. Excel Experts-Exchange Regulars, take 4
    This thread will be kept open indefinitely so the regulars in the Excel Zone can ask for assistance in other questions, share new discoveries, ponder the mysteries of the ribbon, or use a Monte-Carlo simulation to determine the new price of a pint if Shared workbooks weren't ...
  6. Excel Experts-Exchange Regulars, take 5
    As "Excel Experts-Exchange Regulars, take 4" is getting quite long here a newer question for it. Just addapted the text of the previous Q as it says it all. This thread will be kept open indefinitely so the regulars in the Excel Zone can ask for assistance in other...

Free Tech Articles

  1. WARNING: 5 Reasons why you should NEVER fix a computer for free.
    It is in our nature to love the puzzle. We are obsessed. The lot of us. We love puzzles. We love the challenge. We thrive on finding the answer. We hate disarray. It bothers us deep in our soul. W...
  2. SCCM OSD Basic troubleshooting
    SCCM 2007 OSD is a fantastic way to deploy operating systems, however, like most things SCCM issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispe...
  3. Migrate Small Business Server 2003 to Exchange 2010 and Windows 2008 R2
    This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Windows 2008 R2 with Exchange 2010. For this migration to work you will need the fo...
  4. Create a Win7 Gadget
    This article shows you how to create a simple "Gadget" -- a sort of mini-application supported by Windows 7 and Vista. Gadgets can be dropped anywhere on the desktop to provide instant information, ...
  5. Outlook continually prompting for username and password
    There have been a lot of questions recently regarding Outlook prompting for a username and password whilst using Exchange 2007. There are a few reasons why this would happen and I will try to cover t...
  6. Backup Exchange 2010 Information Store using Windows Backup
    There seems to be quite a lot of confusion around the ability to backup Exchange 2010 using the built in Windows Backup feature. This stems from the omission of this feature prior to Exchange 2007 s...

Cloud Class Webinars

  1. Avoiding Bugs in Microsoft Access
    Alison Balter takes and in-depth look at avoiding bugs in Access. In this webinar you will learn about using the immediate window to debug your applications, invoking the debugger, using breakpoints to troubleshoot, stepping through code, setting the next statement to execute, ...
  2. Top 10 Best New Features in Visio 2010
    Scott Helmers gives live demonstrations of the top 10 new features in Visio 2010. This webinar will teach you how to create compelling diagrams by adding shapes to the page with a single click, linking the shapes in a diagram to data in Excel (or SQL Server, or SharePoint), ...
  3. IT Consultant Business Secrets Revealed
    Michael Munger, Experts Exchange tech pro and IT consultant, pulls back the curtain on his very successful businesses and answers question on every IT consultant and business owner should know about. He shares secrets on what he did to solve the 5 most common problems in IT, ...
  4. Disaster Recovery and Business Continuity
    Quest CTO, Mike Billon, gives an overview of the steps involved in building a dunamic disaster recovery plan. Through case studies and an examination of software/hardware tooles for monitoring and testing, you'll gain a better understandin of where you are, where you want ...
  5. Organize Your Visio Diagrams with Containers and Lists
    Scott Helmers uses cross functional flowcharts, wireframe diagrams, data graphic legends and seating charts to teach you: how to ustilize all three new structured diagram components in Visio 2010, the best practices for organizeing shapes in previous version of Visio, how to organize ...
  6. How to Us Objects, Properties, Events and Methods in Microsoft Access
    Alison Dalter gives an in-depbth look at objects, properties, events and methods in Microsoft Access. In this webinar you will learn about using the object browser, referring to objects, working with properties and methods, working with object variables, understanding the ...

Join the Community

Give a Little. Get a Lot.

Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.

Join the Community

Answers

 

by: patrickabPosted on 2008-04-19 at 14:49:04ID: 21394048

Just imagine then what Excel could have done to help Werner von Braun during WW2.

 

by: saurabh726Posted on 2008-04-19 at 14:51:01ID: 21394058

Hmmm im not watching much of TV these days so patrick got no clue about what you are talking....

 

by: byundtPosted on 2008-04-19 at 16:02:40ID: 21394364

Saurabh,
Would it have been more in your ken had I offered the following:

When I bring to you colored cells, my lad,
I understand why there is such a play of highlights on headers, on shapes,
And why selections are painted in tints
when I give colored cells to you, my lad.

When I bring array formulas to your greedy hands
I know how to count with many criteria
And why data is secretly filled with insight
when I bring array formulas to your greedy hands

When I give you RibbonX controls to make you smile, my darling,
I surely understand what pleasure streams from Excel in morning light
And what delight that is which Microsoft brings to my body
when I give you RibbonX to make you smile


Brad

 

by: patrickabPosted on 2008-04-19 at 16:13:05ID: 21394388

>Hmmm im not watching much of TV these days so patrick got no clue about what you are talking....

It's got nothing to do with TV. Just a simple observation following Brad's introduction here which mentioned WWIII.

 

by: byundtPosted on 2008-04-19 at 16:54:32ID: 21394495

Patrick,
I e-mailed you some grist for one of your favorite rants.
Brad

 

by: saurabh726Posted on 2008-04-19 at 22:55:35ID: 21395150

Brad,

Thanx thats a nice song you composed for me....and hey as suggested i did my profile changes.....

Patrick,

Sorry missed out that one...read it again...and got it....

Saurabh....

 

by: patrickabPosted on 2008-04-20 at 01:02:05ID: 21395320

Got it Brad, Thanks for that - Patrick

 

by: byundtPosted on 2008-04-20 at 09:30:45ID: 21396620

Saurabh,
Just to keep the record straight, the "song" was written by one of India's greatest poets. I changed some words to fit the situation and my bride,who knew the original poem, was ROFL when I read it out loud. All of the grace and imagery should be attributed to Rabindranath Tagore, and I wish I could read it in Bengali to fully appreciate its majesty.

Brad

 

by: saurabh726Posted on 2008-04-20 at 11:35:19ID: 21397133

Oh Rabindra Nath Tagore....he wrote our Indian National Anthem as well.....and he was a gr8 guy...and Bengali is quite similar to our native tongue which is Hindi...If you want to know more about India..Can tell you about it....

Saurabh...

 

by: roryaPosted on 2008-04-21 at 07:43:14ID: 21402322

Was the MVP Summit good for those who managed to go?

 

by: mvidasPosted on 2008-04-21 at 07:51:16ID: 21402436

You missed a great time, Rory! Hopefully you'll be able to make it next year (first week of March) :)

 

by: roryaPosted on 2008-04-21 at 08:05:15ID: 21402613

If I get invited, I'll do my best! :)
(at least those dates don't clash with my wedding anniversary!!)

 

by: matthewspatrickPosted on 2008-04-22 at 08:54:09ID: 21412385

rorya said:
>>Was the MVP Summit good for those who managed to go?

It was a real treat.  Being able to meet my heroes in person was awesome: Kevin, Brad, Matt,
Shane (a sometime contributor here), and other guys like J-Walk, Ken Puls, Chip Pearson, Rob
Bovey, Bob (aka xld and many other handles), Zack, and many others, some from other
disciplines.  No particular order, of course, and no slight intended toward the many I did not
list.

One thing I can share with you: Microsoft *is* listening.  We cannot get all of what we want, but
the company is making an effort to get feedback from us power users, and to give us what we
are asking for where it makes sense.

 

by: roryaPosted on 2008-04-22 at 09:07:32ID: 21412533

Patrick,
Thanks for the feedback - good to know!
It would be nice to find out if you guys bear any resemblance in person to the characters living in my head... :)
Rory

 

by: zorvekPosted on 2008-04-22 at 11:31:28ID: 21413991

>Was the MVP Summit good for those who managed to go?

It was fantastic! Meeting the people who make Excel, listening to Steve Ballmer speak, being asked what we think their focus should be and how they have been doing. And then there were the social events and getting to know our peers. Pretty cool. It was the first "business" trip I have taken in a very long time (I HATE to travel for business having done so to an extreme in an earlier life) and I have already marked my calendar for the next one. It was a real treat.

Kevin

 

by: byundtPosted on 2008-04-22 at 12:28:07ID: 21414587

<<if you guys bear any resemblance in person to the characters living in my head>>

Yup. Kevin was exactly like that.

 

by: roryaPosted on 2008-04-22 at 12:44:15ID: 21414765

:) Figured as much!

 

by: patrickabPosted on 2008-04-22 at 13:14:03ID: 21415100

It's good to hear that Microsoft are listening to real users of Excel. However are they just listening and keeping the delegates happy or are they actually going to translate those ideas, requests, comments and suggestions into a better product. I suppose only time will tell.

Not that I would ever qualify for an invitation, but if I ever did I'm afraid I'd decline it, as it's not a country that I will ever visit. I'm sure you folks are excellent guys - so please don't take it personally.

 

by: zorvekPosted on 2008-04-22 at 13:30:57ID: 21415286

>it's not a country that I will ever visit...so please don't take it personally
I'm pretty disgusted with my country so I wouldn't visit us either. However, we have managed to devalue ourselves to the point where the Pound will by a lot more than the Dollar...at a minimum you could find some bargains...

>However are they just listening and keeping the delegates happy or are they actually going to translate those ideas, requests, comments and suggestions into a better product
When Steve Ballmer says in no uncertain terms "if anyone, and I mean ANYONE, at Microsoft does not return your email, I want you to tell me about it personally" and then gives us his personal email address, I think they are listening to us. Put another way, there were whole sessions (the Excel extensibility session for example) where the focus was mostly on what Microsoft can do to make the product better in a way that works for us, not them, and not telling us how we should be using it or what it will be. Business cards and emails were exchanged. As far as I could tell it was genuine.

>Yup. Kevin was exactly like that.
Hmmm...

 

by: saurabh726Posted on 2008-04-22 at 13:46:11ID: 21415416

I have a quick question....

Would i get anything extra as in additional powers or something once i become a Genius in EE...???

Saurabh...

 

by: mvidasPosted on 2008-04-22 at 13:47:30ID: 21415436

You'd get access to the secret drunken picture archive of the excel group.. with new shots from the summit!

 

by: zorvekPosted on 2008-04-22 at 13:49:01ID: 21415451

And there was most certainly some drunkenness at the summit!

 

by: zorvekPosted on 2008-04-22 at 13:49:33ID: 21415455

Matt - posts to this thread don't count.

 

by: mvidasPosted on 2008-04-22 at 13:51:41ID: 21415479

They don't? Dang.

The rest of you should have seen Kevin there.. couldn't keep him sober!

 

by: saurabh726Posted on 2008-04-22 at 13:53:47ID: 21415498

Hmm so i just would get 1 certificate + 1 shirt + Access to the secret drunken pictures...Hmm i see sounds like intresting.....

And hey i guess i would be the youngest genius...as im only 26..anyone younger then me out here and a genius..??

Saurabh...

 

by: zorvekPosted on 2008-04-22 at 13:55:08ID: 21415517

Martinis and margaritas and beer for breakfast, woohoo!

 

by: saurabh726Posted on 2008-04-22 at 13:55:23ID: 21415518

And Hey Guys anyone intrested to know what happened lately with my EE T-shirt...??

Saurabh...

 

by: zorvekPosted on 2008-04-22 at 13:56:50ID: 21415534

It's on a boat somewhere in the Pacific, hopefully headed west.

 

by: zorvekPosted on 2008-04-22 at 13:59:02ID: 21415554

Matt, post this:

   "You can't do that (without VBA)."

here:

   http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_23344493.html

I'll go find 9 more for the day for you.

Kevin

 

by: saurabh726Posted on 2008-04-22 at 14:00:16ID: 21415573

Nopes...well in India we get it by postal service..and since i put up in a society..so thats get to my society gate from where i have to collect it...Now this master T-shirt got it delivered out there and i never came to know about it..Untill when i found out that my security Guard supervisor is wearing one....I.e. he stole directly from my society gate... :-(

Saurabh...

 

by: saurabh726Posted on 2008-04-22 at 14:01:50ID: 21415585

Kevin...

To find 9 more its quite easy...just visit sharath profile and check for his recent questions...and you would get ample amount of questions there.....

Saurabh...

 

by: zorvekPosted on 2008-04-22 at 14:02:27ID: 21415594

Translation please?

 

by: saurabh726Posted on 2008-04-22 at 14:04:02ID: 21415606

Translation of wht...??

 

by: mvidasPosted on 2008-04-22 at 14:05:53ID: 21415622

Hey I've posted to 4 threads the past couple days (ones that "count") when I've found time, I don't have long enough to come up with the VBA for that other thread so its all yours.

Think I'll still stay clear of sharaths questions for now until I find one I can answer without looking it up in google

 

by: zorvekPosted on 2008-04-22 at 14:11:57ID: 21415670

:-)

"Nopes...well in India we get it by postal service..and since i put up in a society..so thats get to my society gate from where i have to collect it..."

I think you are saying...

"No, ships don't deliver my mail, the postal service does. And, since I live in a community where the mail is delivered to a common area, I suspect the community security guard supervisor stole my t-shirt. My suspicions were confirmed the other day when I saw him wearing an Experts Exchange Master t-shirt and he doesn't even have a computer."

 

by: saurabh726Posted on 2008-04-22 at 14:15:15ID: 21415697

Yes Kevin...thats what i meant...and the best part is you are talking about computers...He doesnt even know what in the world is EE or what is a computer...He is illiterate....

And a Society in India is like you have area build up in which you have some flats and then you have a common security guard for all those flats...

Saurabh....

 

by: saurabh726Posted on 2008-04-22 at 14:18:12ID: 21415722

And any particular reason why this happens in excel 2007...

http://www.experts-exchange.com/Software/Office_Productivity/Spreadsheets/Q_23338007.html

As i have tried to google the issue but havent found any concrete answers till now which exactly nails down the problem...

Saurabh...

 

by: patrickabPosted on 2008-04-22 at 14:19:37ID: 21415732

>And hey i guess i would be the youngest genius...as im only 26..anyone younger then me out here and a genius..??

I dunno the stats on that, but I'd care to guess that at 63 I'm the oldest in the Excel TA who's mentioned in its 'front page'! And what's more no one gives me any special T shirts for that - but then why should they.

 

by: saurabh726Posted on 2008-04-22 at 14:23:13ID: 21415764

Hey Patrick...

I didnt knew that you are the oldest...And you are mentioned on the front page of EE...thats cool...Man you guys really rock and have ample knowledge of excel...Im just a new born baby for you guys....

Saurabh....

 

by: patrickabPosted on 2008-04-22 at 14:28:17ID: 21415796

>I'm pretty disgusted with my country so I wouldn't visit us either.

I am ashamed to admit to being British. However I must not turn this thread into a political discourse. However it's encouraging to hear that I don't hold my views alone.

>...As far as I could tell it was genuine.

Kevin, that is truly encouraging. I wonder if they will really hold up their end of the bargain as the months roll by - I do hope so.

 

by: patrickabPosted on 2008-04-22 at 14:31:00ID: 21415810

Saurabh,

Ah but:

greater age<>greater knowledge
greater age = greater need to learn
lesser age = greater ability to learn

Patrick

 

by: saurabh726Posted on 2008-04-22 at 14:36:00ID: 21415846

Patrick i agree to you over that...with my age but what i meant to say is experience as knowledge comes with experience only..when you try and test things...but what you said is also valid...and definately makes sense...

And have you guys ever been to India...??Its a great place to be... and i love things out here....if you guys ever get a chance...do visit...and if you need any help..just give me a buzz...i would make sure everything goes fine.....

Saurabh..

 

by: patrickabPosted on 2008-04-22 at 14:47:29ID: 21415895

Saurabh,

That is a great offer. I have never really been to India, only stopped en-route to the Far East. My brother is a frequent visitor to India and he loves it. In what part of India do you live?

Patrick

 

by: saurabh726Posted on 2008-04-22 at 14:51:09ID: 21415922

Patrick,

I live in New-Delhi which is the capital of India...and being Capital its one of most developed city that you can think about..But i got connections all over in India..Since things what i meant is specially relationships works completely different in this part of country if you compare from rest of the world..

Saurabh...

 

by: patrickabPosted on 2008-04-22 at 14:57:56ID: 21415966

Saurabh,

My brother and sister-in-law go on walking holidays in the low foothills of the Himalayas. They usually go as a group or 12 to 14 friends - mostly medics.

Patrick

 

by: saurabh726Posted on 2008-04-22 at 15:06:46ID: 21416014

Patrick..

They must be visiting Nepal which is another country right next to India and then Himachal and Uttranchal one of the beautiful places in India to go...

I think the major differences which i have obsereved myself is the culture and the food...Dont meant to offend anyone..but the food shux big time of US and UK...its just tasteless as in all it has cheese and salt..thts it...but out here you get food which you would just love to eat and which is spicy and full of taste...which you love eating...

Saurabh...

 

by: roryaPosted on 2008-04-22 at 15:07:31ID: 21416018

My wife says I have a mental age of 4 - does that qualify me as the youngest Genius? ;)

 

by: patrickabPosted on 2008-04-22 at 15:09:38ID: 21416033

>My wife says I have a mental age of 4 - does that qualify me as the youngest Genius? ;)

Absolutely - congratulations.

 

by: saurabh726Posted on 2008-04-22 at 15:11:49ID: 21416051

Rory..Yups...Congrats....Now i know who is the youngest one....

Rory..Are you from US Too..??

Saurabh...

 

by: saurabh726Posted on 2008-04-22 at 15:13:34ID: 21416063

Forgot what i asked...You from Uk....And i was searching for the word...for the food..what i meant to say its blunt.....

Saurabh

 

by: roryaPosted on 2008-04-22 at 15:13:55ID: 21416065

Nope, I'm in the UK. Had a job offer in the US a while ago, but it was in Utah... :)

 

by: saurabh726Posted on 2008-04-22 at 15:15:21ID: 21416081

Rory...U ever been to India...??

 

by: roryaPosted on 2008-04-22 at 15:15:44ID: 21416085

Saurabh,
I think you mean bland, rather than blunt.

 

by: patrickabPosted on 2008-04-22 at 15:17:26ID: 21416104

Saurabh,

No, they stay in India and have so far not visited Nepal or Bhutan. They walk up to about 17,000ft over a two week period. They keep well away from other Europeans as they enjoy getting to know and understand the people whose villages they travel through. They always come back totally enthusiastic and with super photos of people, places and views.

Patrick

 

by: roryaPosted on 2008-04-22 at 15:17:34ID: 21416106

No, I've never been there - my Dad lived there for a while I think but that was before I was born.

 

by: saurabh726Posted on 2008-04-22 at 15:18:00ID: 21416110

Hmm well in short what i meant is tasteless....

 

by: roryaPosted on 2008-04-22 at 15:19:49ID: 21416121

Yep - bland. Not all English food is bland though, if only because curry is pretty much a staple English dish these days!

 

by: saurabh726Posted on 2008-04-22 at 15:22:21ID: 21416145

Patrick...

I understand what you meant to say as its really fun out here...

Rory....

Thats way long back.....


Neways i got to go guys..Time to catch on sleep..its 4 in the morning out here....Its nice talking to you guys...and i just have a suggestion that we guys should intreact with each other quite often rather then just excel to attleast know each other better..rather then just what we do.....

Saurabh...

 

by: saurabh726Posted on 2008-04-23 at 12:52:29ID: 21424643

Any Excel Zone Advisor here...i want to report something...that i want there attention on....

Saurabh...

 

by: byundtPosted on 2008-04-23 at 13:55:26ID: 21425293

Saurabh,
What is the issue?
Brad

 

by: saurabh726Posted on 2008-04-23 at 13:56:20ID: 21425305

Brad...Thanx Kevin helped me out...i wanted to re-open a question....

Saurabh...

 

by: patrickabPosted on 2008-04-27 at 05:23:17ID: 21448918

Good afternoon Experts,

I am trying to find a question in the Excel TA that relates to Chart Trend lines. The question was how to extract the Trend Line formula from it's label form and to make use of it as a formula. Someone cracked it but I failed to keep a record of it. Can anyone help me locate that question.

Thanks to all.

Patrick

 

by: patrickabPosted on 2008-04-27 at 12:22:46ID: 21450095

Rory,

Thank you for that. I've created another solution - it's here:

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_23346722.html

What's odd is that as I was involved in the original, which you found, I could find no trace of any file on my hdd.

Anyhow thanks for your help.

Patrick

 

by: saurabh726Posted on 2008-04-29 at 13:50:22ID: 21466070

Hi Guys...

Just wanted to check anyone have you incase have worked something similar to this....

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_23363438.html

Thanks for all your help and looking...

Saurabh...

 

by: mvidasPosted on 2008-05-13 at 09:40:50ID: 21556815

Didn't want this one to sneak past anyone here

http://www.microsoft.com/presspass/press/2008/may08/05-13MacBU2008PR.mspx

Most notably:
"The group also is providing a glimpse at the road map of Office for Mac by announcing the return of Visual Basic for Applications (VBA) in the next version."

 

by: matthewspatrickPosted on 2008-05-13 at 11:32:47ID: 21557880

WHich begs the question: what made the Mac BU think getting rid of VBA was a good idea in the
first place?

:)

Regards,

Patrick

 

by: zorvekPosted on 2008-05-20 at 13:45:59ID: 21610187

My buddy Tim Zych (TZych) has finished building his super cool worksheet comparison tool, Workbook Compare. I've taken a look and it looks pretty powerful. For now Tim has decided to keep it freeware. Tim used to hang out here as an expert and thought you guys would like to check it out. You can check it out here:

   http://www.higherdata.com

Let him know what you think!

Kevin

 

by: saurabh726Posted on 2008-05-20 at 14:19:33ID: 21610468

Hi Kevin,

This actually awsome...i have couple of suggestions...

Saurabh...

 

by: patrickabPosted on 2008-05-22 at 09:34:59ID: 21625383

Don't usually do this, but I find it so hard to believe that I'd welcome input from anyone who has the time to have a quick look at my very simple question:

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_23424457.html

Patrick

 

by: byundtPosted on 2008-07-01 at 16:15:03ID: 21912357

I am pleased to announce that earlier today Microsoft announced MVP awards for 2008 for at least five of the Regulars: Kevin, Matt, Patrick M, and Rory. I haven't heard yet from Jim--which would make six.

It's a real tribute to the quality of support provided by the Regulars in the Excel Zone at Experts-Exchange. Microsoft values professionalism as the most important virtue. It also helps to be prolific, smart and know the product inside-out. And when I look at the quality of the Regulars, I'm sure that the MVP lead found it hard to figure out where to stop when picking so many from the same place.

It is worth noting that there are four MVP award dates: July 1, October 1, January 1 and April 1. This spreads out the workload of evaluating (or re-evaluating) all the nominees for the MVP Lead. It also means that there is a chance of adding to the list of honorees later this year.

Woohoo!

Brad

 

by: saurabh726Posted on 2008-07-01 at 16:16:56ID: 21912366

Hey Man...

You guys rock....Thats a gr8 news Party time....

Saurabh...

 

by: roryaPosted on 2008-07-01 at 16:22:48ID: 21912378

Go team! Congrats, guys - nice to see the "Woohoo" again too! ;)
Rory

 

by: zorvekPosted on 2008-07-01 at 16:31:22ID: 21912411

While Brad indicated there were five awardees he failed to indicate who the fifth was. For those who are regulars, you of course know it's Brad. I'm going to take this moment once again to espouse just how influential Brad is on this zone and consequently the destinies of many of us here. When I first started answering questions about four years ago Brad was the king of the hill. He was the sheriff, the top expert, and was answering questions at a blistering rate. One member referred to Brad's working here as "shooting fish in a barrel".

But Brad wasn't just the fastest and most accurate gun. He mentored us, he was always fair, he taught us the intricacies of array formulas and how to post with dignity and respect for the Asker and the other Experts. He set the tone for the zone for as long as I can remember. And it's the tone - the demeanor and respect we have for the Members and our fellow Experts - that has caught the eye of Microsoft in addition to the sheer volume of questions answered. I really can't say where I would be if it wasn't for Brad but I can definitely say that he has helped me grow as an Expert, as a Microsoft MVP, and, most importantly, as a person.

As for Rory, June of 2009 is a ways down the road so it's time for a holiday. And you had better show up at the Summit. No more excuses.

Kevin

 

by: saurabh726Posted on 2008-07-01 at 16:39:04ID: 21912427

Hey Kevin...

I completely agree with you over that as i haven't interacted much with Brad till now but the way he posts and interacts with other experts always politely and the most important part he is always helpful and when no one is here you would find him here helping you out...

Saurabh..

 

by: roryaPosted on 2008-07-01 at 16:51:34ID: 21912484

I think the summit is out of the question next year, so I will have to hope the madness extends into 2010.
And I second your sentiments about Brad, which apply to your good self too - when you're not being a douche, obviously. :)
I have used many different forums over the years and rarely stay too long as the lack of etiquette gets to me (and I do mean 'etiquette' rather than 'netiquette'; plain old-fashioned manners and civility). This place is one of those rare exceptions and that's down to the fact that the people who hang around here are generally nice to each other; that, in turn, is down to you guys, for which I sincerely thank you (though my wife doesn't like you much!).
Rory

 

by: patrickabPosted on 2008-07-01 at 17:05:50ID: 21912528

To: Brad, Rory, Kevin, Matt, Jim and Patrick M

Many Congratulations on your MVP awards - all well deserved.

Patrick A-B

 

by: zorvekPosted on 2008-07-01 at 17:06:21ID: 21912532

Now I am REALLY curious. The Summit is not until March of next year, we have the exact dates, and you are still deciding at this time that you won't be going? What is it that is that important and that long term that leads you to that outcome so soon? Wife pregnant? Surely it can't be work related given the amount of time you spend keeping EE members happy. Dude, the last Summit was blast! Not something you want to miss too often.

Oh, and Rory, for what it's worth, I perceive your etiquette skills to be at the top of the heap too :-)

 

by: roryaPosted on 2008-07-01 at 17:24:53ID: 21912606

I cannot comment at this time. :)

 

by: zorvekPosted on 2008-07-01 at 17:49:58ID: 21912669

Aha! I'll mark the date ;-)

 

by: roos01Posted on 2008-07-01 at 22:37:51ID: 21913707

Congrats guys!!!!

Jeroen

 

by: byundtPosted on 2008-07-02 at 05:11:48ID: 21915434

Jeroen,
I took a look at your member profile yesterday, and was impressed by the way you have rewritten it. It tells the reader more about you as a person, what you do in your day job, and the qualities you value about the site and its members. The links to collaborations between you and other experts on the site were a nice touch.

Well done!

Brad

 

by: roos01Posted on 2008-07-02 at 05:39:17ID: 21915677

Thanks Brad,
I wished I could spend more time here so I could add more value to my profile. At the end of last year I did very well and hoped I could get my 2M then, So it will be my goal for this year. Writing this made me aware that time flies even when your not on EE. Only time on EE counts as Im still not on the 2M.

The only part I currently change is when I made some cleanup proposals :)
At least in that way Im also involved in many questions.

 

by: byundtPosted on 2008-07-04 at 22:10:22ID: 21935918

Those of you with Excel 2007 might find the built-in help for names somewhat bizarre. Navigate to Formula and name basics...Working with names. The on-line help is the same as always--the treat is in the offline. Methinks an English major has run amok.

"What's in a name? That which we call a cell range, function, constant, or table would tally and toil just as sweetly..."

 

by: byundtPosted on 2008-07-16 at 18:58:21ID: 22021826

If you were a bit mystified a half dozen posts above, the penny dropped here: http:/Q_23571642.html#22021218

 

by: saurabh726Posted on 2008-07-22 at 12:22:41ID: 22062710

 

by: zorvekPosted on 2008-08-07 at 08:50:40ID: 22182190

 

by: brettdjPosted on 2008-08-07 at 09:02:22ID: 22182318

Hi Kevin,

The family and I are have relocated to London for a year or so while my company's offer for a major competitor plays out

Rachael (the baby face on my old dup master site) is now 5, and being the UK, she is attending school here. Back home she would have started in Jan 2009, over here her classmates started in Sept 2007. Even more scary is that my son, just having turned 3, starts nursery school for five days a week next month. They won't know what hit them.

London has been great, brilliant weather and much to see and do. Although we are a long way from home, which makes it a little hard on Lucy to fully occupy all her time without the normal social networks.

This recent work has seen me back into hands on excel model design, and a little bit of automation to manage the many different files floating around. So for the first time in a couple of years I'm dabbling in VBA again. I've only just seen Excel 2007 for the first time - purchased in case my model gets too large - and its going to take quite some time to acclimatise to the ribbon let alone the new functionality.

trust all is going well

Regards

Dave

 

by: patrickabPosted on 2008-08-07 at 16:23:42ID: 22186383

Dave,

Welcome to Britain. I trust you and your family will enjoy your stay here. I do hope you manage to get out of London and see something else of Britain other than the capital even though it has plenty to look at. I live out on the Met line - about 30 minutes from Baker Street tube station - so visits to London are easy for us.

Our older daughter lives in Wapping (north bank of the Thames and east of Tower Bridge) near London's oldest pub - The Prospect of Whitby. It's worth a look and a drink as it's not far from St Catherine's Docks which in turn is near Tower Bridge and the Tower of London. After all you've got to do the standard rubber-necking stuff at some moment whilst you're here. Crown jewels and all that.

Have a great time.

Patrick

 

by: brettdjPosted on 2008-08-09 at 05:10:19ID: 22196017

Thanks Patrick

We should grab a beer sometime,  pls shoot me an email

I ducked down to Brighton for a day recently. Beautiful spot, but I was completely taken back by the pebble beach, I am so accustomed to the sandy beaches back home that I had never considered the idea of people lying on pebbles. We have made lots of tube and bus trips to the likes of Greenwich & Hampton Heath, and the museums just down the road off Brompton St are brilliant.  When the work slows down we will get up to Scotland, Wales and Ireland as well

The other bright spot is being so close to Europe. We ducked off to Interlaken and then Salzburg for a quick break a few weeks ago. Whereas back home I am accustomed to driving 3000 kms ecah Christmas in a triangle to visit both sets of grandparents. Not having a car here is a very welcome change

Cheers

Dave

 

by: patrickabPosted on 2008-08-09 at 07:58:59ID: 22196483

Dave,

I've emailed you through vbaexpress.com

Patrick

 

by: webtubbsPosted on 2008-08-16 at 17:01:54ID: 22245633

hey guys, we need some more help here -> http:/Q_23654024.html

 

by: brettdjPosted on 2008-09-01 at 15:27:46ID: 22363159

Patrick,

Did you email my vbaexpress address - its a spam zone so I think I've missed it

Cheers

Dave

 

by: patrickabPosted on 2008-09-01 at 15:46:27ID: 22363212

Dave,

I emailed you ages ago and so far, despite searching, have failed to discover your email address. I even considered emailing you at work but thought that would be intrusive. So I've been hoping you would return here. Where can I find your email address as it''s not in your profile. I did try signing up to your contact system but it seemed just a bit too complex to achieve something simple - so I've waited!

Patrick

 

by: brettdjPosted on 2008-09-02 at 01:50:16ID: 22365240

Patrick,

work email is fine, thx for taking that into consideration

David dot Brett at  (take the company part from http://www.bhpbilliton.com)

Cheers

Dave

 

by: patrickabPosted on 2008-09-02 at 02:14:18ID: 22365357

Dave,

Thanks for that. I'd guessed that was your email address as I had already discovered the name of the company you worked for as well as it's London HQ address. I will send you the email the straightaway.

Patrick

 

by: patrickabPosted on 2008-09-06 at 14:29:43ID: 22409101

Dave,

As promised, I emailed you. Hope you received it.

Patrick

 

by: brettdjPosted on 2008-09-06 at 16:16:27ID: 22409400

Patrick,

I did - I replied to you a few days back. I will resend

Cheers

Dave

 

by: patrickabPosted on 2008-09-07 at 02:31:55ID: 22410660

Dave,

I believe my spam filter must have zapped the incoming email. Sorry about that.

May I ask you to send it again to the same address. I have modified my spam filter so that your email address is in the 'allow' list but just to make sure I receive it, could you also send it the same addressee but at googlemail.com.

Regards

Patrick

 

by: zorvekPosted on 2008-09-07 at 23:24:37ID: 22414976

Another candidate for the Experts Exchange Excel addicts group meetings:

http://www.experts-exchange.com/Q_23711197.html

Kevin

 

by: patrickabPosted on 2008-09-09 at 10:27:59ID: 22429915

Dave,

I think you missed my last message here...

I believe my spam filter must have zapped the incoming email. Sorry about that.

May I ask you to send it again to the same address. I have modified my spam filter so that your email address is in the 'allow' list but just to make sure I receive it, could you also send it the same addressee but at googlemail.com.

Regards

Patrick

 

by: byundtPosted on 2008-09-13 at 21:34:33ID: 22471141

I've added some following tips on asking and answering questions to my user profile. I'd appreciate any Excel-specific suggestions or improvements you might be able to offer. I want us to have the highest quality zone in Experts-Exchange, and good questions and good answers play a large part in it.


Want to ask a better question?
1) Give us both the overall problem and the specific request. You may think that the best way to solve your overall problem would be if you only knew how to do xyz--but the people trying to help you have a whole lot of experience with Excel and just might know an even better way.
2) Many problems can be solved with either a macro or a formula/worksheet user interface tricks. You may get both approaches suggested. If for some reason, you absolutely have to have one or the other approach, please tell us that desire in your initial question.
3) Which version of Excel do you use? Always let us know, because the answer or the explanation frequently depends on it.
4) Whenever possible, post a sample workbook showing both the starting point and the desired results. Excel puts three worksheets by default in each workbook--this is a good reason for two of them. If your real data is confidential, consider posting made-up data that replicates the problem. We don't need a lot of data--10 or 20 properly selected lines is sufficient in most cases.
5) If you encounter an error message, please post its text. Let us know which line of code triggered it. If it only occurs with certain inputs, let us know that too.
6) If you have tried and failed to do something, please include your failed attempts in your sample workbook. We might be able to tweak it here and there more quickly than developing something from scratch.
7) Even though the steps to reproduce the problem are obvious to you, it may not be so obvious to someone opening your sample workbook. Which worksheet should we look at? Which cells? Which macro do we run?


Want to get a better answer to your question?
1) Pay attention to your In Box. You'll get responses within minutes in most cases. If additional information is requested, please provide it. If solutions have been proposed, please test them. Let us know of any shortcomings.
2) The more you interact with the experts, the better the answer will be. Let us know which parts you don't understand and which features are still missing from the suggestions. These interactions are more fun for the people trying to help--and since we are all volunteering our time, more fun is a good thing.
3) Review the suggestions made by all parties. The expert making the most posts doesn't necessarily have the best solution. Another expert might take pride in posting a complete answer the first time.


Picking the Answer
1) If more than one right answer is offered, which one will you actually use?
2) When more than one person offers the same suggestion, everyone understands if you pick the first embodiment. But if a later post offers supporting discussion that you found valuable, people will understand a split in points or even full credit if you explain your reasoning.
3) If you aren't completely happy with the suggestions made so far, keep the question open for another day. We have good experts in this zone from all around the world, and the one you need might be asleep or busy at his day job.



Want to get more "Good Answer" e-mails?
1) Test your suggestion before posting it. Make up data if the Asker didn't provide any. This allows you to catch mistakes in your suggestion as well as the two or three other errors that the Asker didn't mention in the original question.
2) If somebody else posts in a question you are working on, test their suggestion as well. Sometimes, it will be better than yours. Other times, you may realize that you and the other expert made different assumptions. If so, highlight the different assumptions so the Asker is aware of them.
3) Give credit to the other expert. Even if you developed your suggestion independently, acknowledge the similarities and discuss the improvements you are making.
4) Read the entire thread, including the posts by other experts. Before hitting that Submit button, make sure that your post offers either a palpably better solution--or that you provide additional information the Asker may find helpful. You'll find that posting good information in fewer threads will build you a better reputation as an expert.
5) Always post your formula and code in the Comment or Snippet. Even if you post a sample workbook, the formula and code should always appear in the thread too. This practice makes it easy for other people to scan the thread and realize that you already have matters under control. It also makes the thread more valuable in the EE database.
6) Add comments to those parts of your code that the Asker might need to change. Put textboxes on worksheets with instructions--I compose many EE Comments that way.
7) If you do post a workbook, delete the unnecessary worksheets.

 

by: matthewspatrickPosted on 2008-09-14 at 10:07:04ID: 22473418

Brad,

Nicely done.  The only thing I would add is to the "post a sample whenever possible" point.  I would expand
that a bit to say something like, "if you are worried about revealing confidential, proprietary, or otherwise
sensitive information, then make up some fake data".

Regards,

Patrick

 

by: byundtPosted on 2008-09-14 at 10:17:19ID: 22473451

Patrick,
Thanks!

I updated my verbage to reflect your suggestion.

Brad

 

by: brettdjPosted on 2008-09-14 at 12:09:35ID: 22473851

Brad,

This is excellent.

It may be useful to separate out a brief etiquette piece in each section, ie for Askers covering proper question close-out wrt grading and point's sharing. You have covered the major etiquette points for Experts already (ie  credit to others, read the entire thread etc).

i sugest that Expert Point 4
"Make sure that your post offers a palpably better solution in one or more respects."
could be modified along the following lines
  .. .."If another Expert has 'answered' a question as asked, then you should only post if you can provide a palpably better solution, or if there are potential issues for others who may look to adapt or apply the solution beyond the immediate question. In either case it may be appropriate to preface your post with "not for points".

Cheers

Dave

 

by: patrickabPosted on 2008-09-14 at 12:55:17ID: 22473982

Brad,

That's a good list. However, one question - How do you intend to bring it to everyone's attention? My comments are:

Under "Want to ask a better question?"

I believe it would sound better to change it to:

"...but the people trying to help you have a whole lot of experience with Excel and just might know an even better way.

Point 4 might benefit ffrom adding:

4) Whenever possible, post a sample workbook showing both the starting point and the desired results. Excel puts three worksheets by default in each workbook--this is a good reason for two of them. If your real data is confidential, consider posting made-up data that replicates the problem. However please submit only the minimum amount of data that illustrates the problem - that will minimise file size and speed up downloading.

Under "Want to get more "Good Answer" e-mails?"

It might be useful to put something like this in the list of do's (not sure Lynne Truss would approve of my use of the apostrophe)

n) If you need clarification from the Asker do not hesitate to ask for it. That can help the Asker define more accurately the problem that needs to be solved.

Patrick (A-B)


 

 

by: byundtPosted on 2008-09-14 at 13:26:57ID: 22474140

Patrick (A-B),
Thanks for the great suggestions! I tried to incorporate their gist in the original post.

My original intent was to make the suggestions part of my member profile. If EE permits, it wouldn't hurt to have links to them in the Excel Zone. They're Excel specific, and so would be less useful if part of the overall site FAQ.

I posted in this thread both to get feedback as well as to encourage the other regulars to repurpose the discussion as you see fit.

Brad

 

by: patrickabPosted on 2008-09-15 at 14:00:33ID: 22482807

Brad,

Is this correct?

"Or rather with the "Microsoft Forms 2.0 Object Library". This library has issues, especially when you save the file with different versions of Excel (2007 was very bad, at least before the first SP)...."

That statement was made by 'harfang'. I've not encountered problems with it previously. I'd appreciate your opinions on the matter. I've closed the question in which he made the statement but all the same 'I hae me douts on the matter' as they might say in Scotland. The question was:

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_23728533.html

Patrick

 

by: roryaPosted on 2008-09-15 at 14:41:01ID: 22483213

FWIW, I've never had issues with it. I have read of occasional problems for people using 2007 (but then there seem to be a lot of odd problems there) with workbooks created in previous versions, but I can't think of any offhand with any prior versions (other than possibly your question above!)
Rory

 

by: zorvekPosted on 2008-09-15 at 14:47:01ID: 22483256

I concur with Rory. The only time I have version issues is when I reference the Word object library and for that I use late binding. Unfortunately, when using the DataObject object to use the clipboard, there is no way to use late binding that I have been able to discover. Fortunately, I have never had a problem with the Forms 2.0 library in 2007 or other versions.

Kevin

 

by: byundtPosted on 2008-09-15 at 14:58:22ID: 22483312

Patrick,
I've encountered the odd problem when using an ActiveX command button to run a macro doing stuff on a different worksheet--but rebooting always seemed to sort it out.

Kevin, however, views ActiveX controls with gimlet eye, in the same vein as Shared workbooks, rounding intermediate results or violating the sacred rules of User Interface design.

I'm glad you got the discussion with harfang straightened out. I very much enjoyed meeting him at the recent CORE conference in San Luis Obispo--and I'd hate to see two good friends remain at loggerheads.

Brad

 

by: saurabh726Posted on 2008-09-15 at 15:00:13ID: 22483328

Guys...I just have one query...When i am getting Invitation for these conferences..???

Saurabh...

 

by: patrickabPosted on 2008-09-15 at 15:12:13ID: 22483404

Rory, Kevin and Brad,

Thanks for your quick and interesting responses. Even though the suggested solution seemed to fix the problem, I am still not convinced by harfang's explanation. Oh well, it's not that important.

Patrick

 

by: patrickabPosted on 2008-09-15 at 15:18:13ID: 22483434

Saurabh - Eh? - Patrick

 

by: patrickabPosted on 2008-09-15 at 15:18:52ID: 22483439

Saurabh - Only kidding... - Patrick

 

by: zorvekPosted on 2008-09-15 at 15:19:05ID: 22483440

>Kevin, however, views ActiveX controls with gimlet eye.

Only on worksheets - they have numerous issues when enclosed in shape containers on a worksheet and are one of three main culprits of workbook corruption - the other two being excessive formatting and VBA code. When working with user forms you have to use ActiveX controls and, in that context, there are no real issues. Missing or lame functionality perhaps, but no issues.

Kevin

 

by: saurabh726Posted on 2008-09-15 at 15:19:25ID: 22483443

Patrick...

I dont get invitation to anywhere...and neither i got the key when i became genius...

Saurabh...

 

by: patrickabPosted on 2008-09-15 at 15:27:18ID: 22483467

Saurabh,

I never got the key to the executive suite either. However I did receive a most excellent write-up from Brad, but when I passeed the 2 million mark no one even commented! Perhaps it's just expected once one's over the 1 million mark.

As for inivitaions well, I've no idea who issues them or on what basis they are issued. Perhaps you and I have the wrong type of passport. These ex-colonials have there own way of doing things.

Patrick

 

by: saurabh726Posted on 2008-09-15 at 15:34:24ID: 22483497

Patrick...

I didnt even get that...and you know what the worse part...Brad even wished me...see....

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_23496466.html

Hmm...and i know u working for 2 Million points...when you were there everywhere....

And Inivations...Hmm dont worry...im optimistic...see im 27...by the time i grow old...lets say 42 or 43...i would be the one sending invitations...and thats what my target is to achieve...

Saurabh...

 

by: zorvekPosted on 2008-09-15 at 15:39:01ID: 22483521

Ah, the key...I think one of the other geniuses lost it. Too bad too, there are some great pics of us at some parties.

A month ago Experts Exchange invited a few prolific members to headquarters in San Luis Obispo California for a conference. They were hand selected from the list of Admins, Moderators, and Zone Advisors with a few additional members invited for their outstanding contributions. The primary objective was to learn ways to make the site better. Invitees were selected for their dedication, quality of service, and tenure. But, most importantly, for their ability to provide insight into the subtleties of how Experts Exchange works (and doesn't work) and their ability to articulate that insight in a productive and insightful manner. From what I understand, Experts Exchange will be having another conference next year. From all indications and if the site remains successful, it will be an annual event.

How do you get invited next year? I suggest continuing what you are doing. In addition, make yourself known to Experts Exchange by posting ideas for improving the site in the Feedback zone.

Kevin

 

by: brettdjPosted on 2008-09-15 at 15:42:57ID: 22483541

>> These ex-colonials
I'm intrigued Patrick, pls expand ??



 

by: saurabh726Posted on 2008-09-15 at 15:46:04ID: 22483560

Ahh Kevin thanks for the insight...but anyways i know myself im still not there at that level because i need to learn a lot which im improvising and working hard upon and the day that i feel im there...i would get an invitation because my feelings generally come true...

Also i try my level best to improve my grammer and english..since its not my mother tongue...but i know i cant count that as an excuse...and there is always a scope of improvement no matter what...

You know the real problem with me is getting the visa...because its really tough to get a visa for usa out here...because of the laws and evertyhing...they are very stringent about it....no exceptions...

Saurabh...

 

by: saurabh726Posted on 2008-09-15 at 15:55:26ID: 22483620

And you know what...i think i have an advantage...because im ahead of you guys by GMT+5:30 hours...so i answer a question before even its asked..since im ahead... ;-) .... Just kidding... its just that when im here...mostly none of you are here..since its wee and odd hours for you guys...so get ample of opportunties to solve questions...with a ample amount of time to work upon....But there is an exception to that and which is Kevin...because he is here most of the times...no matter what... I really wonder what does he do...or what he eats..that he has so much of energy...

Saurabh...

 

by: patrickabPosted on 2008-09-15 at 16:53:50ID: 22483870

Dave,

>I'm intrigued Patrick, pls expand ??

It's a gentle dig at the Americans for leaving the British Empire.

Patrick

 

by: patrickabPosted on 2008-09-15 at 17:00:17ID: 22483909

Saurabh,

>And Inivations...Hmm dont worry...im optimistic...see im 27...by the time i grow old...lets say 42 or 43...i would be the one sending invitations...and thats what my target is to achieve...

Oh my goodness. I don't even fit on your scale of 'oldness'. I might hop the twig in the next few minutes, but if my grandparents are anything to go by, I've got another 30+ years to go and they lived well into their 90's.

You'll get that invitation - I have no doubt. Sheer determination and hard work will get you there.

Patrick

 

by: roryaPosted on 2008-09-15 at 23:35:45ID: 22485369

Kevin,
FYI, you can late bind the DataObject, I've just never seen the need really.
Rory

 

by: zorvekPosted on 2008-09-15 at 23:38:13ID: 22485386

How?

I have searched high and low and taken apart the registry but can't find the name of the library object.

Kevin

 

by: roryaPosted on 2008-09-15 at 23:57:53ID: 22485535

I'll post when I get to work as I'm on a phone now and it's not code I keep in my head!

 

by: roryaPosted on 2008-09-16 at 02:03:22ID: 22486252

Something like this (haven't tested in 2007):

Public Sub CopyCellContents_Sub()
   Dim objData As Object
   Set objData = GetObject("New:{1C3B4210-F441-11CE-B9EA-00AA006B1A69}")
 
   'Same as f2+copy contents.
   
   With objData
      .SetText ActiveCell.Formula
      .PutInClipboard
   End With
 
End Sub
                                              
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:

Select allOpen in new window

 

by: brettdjPosted on 2008-09-16 at 02:13:40ID: 22486294

Well as a convict I'm in the same pack ...

 

by: patrickabPosted on 2008-09-16 at 02:58:43ID: 22486586

Well, not really as until you have that referendum again you won't be a republic - which is what we should be anyway. Don't wish her any harm, but it's time for us to develop as a nation and pension-off the Queen - but then this is not the Politics forum.

 

by: saurabh726Posted on 2008-09-16 at 03:43:51ID: 22486822

Patrick...

You do fit in my defination of old...but its just that i dont want to live for so long...so thats why said 42 is old...otherwise 90+ is also not bad...

Saurabh...

 

by: patrickabPosted on 2008-09-16 at 03:51:28ID: 22486865

Saurabh,

>You do fit in my definition of old...but it's just that I dont want to live for so long...

I predict that as the years pass by your views and aspirations will change.

Patrick

 

by: roryaPosted on 2008-09-16 at 04:07:28ID: 22486985

Live fast, die young, leave a beautiful spreadsheet. :)

 

by: patrickabPosted on 2008-09-16 at 04:13:12ID: 22487022

All depends on your definition of 'young'. Mine is anyone younger than me.

 

by: roryaPosted on 2008-09-16 at 04:21:45ID: 22487107

Mine is (currently) anyone under the age of 40. :)

 

by: saurabh726Posted on 2008-09-16 at 04:50:42ID: 22487299

Patrick...

I agree with you over that as thought process changes with time...and im happy to know that i fit in defination of young for all of you guys...because im younger then all of you...

Rory....lol@ spreadsheet...

 

by: chris_bottomleyPosted on 2008-09-16 at 07:35:02ID: 22488817

'Old' is like tomorrow.  It always changes with the dawn!

Chris

 

by: brettdjPosted on 2008-09-16 at 08:38:57ID: 22489642

You are only as old as the ..... <insert your own str here>

 

by: patrickabPosted on 2008-09-16 at 13:39:52ID: 22493040

>because im younger then all of you...

Where does that leave me?

 

by: roryaPosted on 2008-09-16 at 13:46:37ID: 22493110

I don't know - I'm only 14 but living a virtual life on the internet as a thirty-something geek...

 

by: saurabh726Posted on 2008-09-16 at 13:52:48ID: 22493162

Patrick...Didnt got you...

And yups i agree age is what you think and how old you consider your self to be...

 

by: patrickabPosted on 2008-09-16 at 14:23:43ID: 22493430

>I'm only 14 but living a virtual life on the internet as a thirty-something geek...

Ah, but I'm re-discovering what it was like to be 18 again, but this time without the complications or concerns. :))

 

by: roryaPosted on 2008-09-16 at 14:29:13ID: 22493472

18 year olds are supposed to have concerns?? Now you tell me! :)

 

by: patrickabPosted on 2008-09-16 at 15:05:44ID: 22493744

As I wrote it - I did wonder if I had many concerns at that age.

 

by: matthewspatrickPosted on 2008-09-16 at 17:36:37ID: 22494555

Rory said:
>>18 year olds are supposed to have concerns?? Now you tell me! :)

Patrick A-B said:
>>As I wrote it - I did wonder if I had many concerns at that age.

Well, at 18 I had "concerns", but looking back now at a bit more than twice that age, I have the wisdom to see
that those concerns were in actuality incredibly unimportant.

That's not to say that I have become wise, mind you--I may be twice as wise now as I was then, but seeing as
I only had about half a thimble-full of wisdom at 18, I'm still running short today :)

Patrick

 

by: chris_bottomleyPosted on 2008-09-16 at 22:01:08ID: 22495616

Ah but at 18 there was soon to be supercalc ... excel what is that?   So since this is the excel regulars I perhaps ought to say that in hose days things were not so good since there was no excel but it's not a (pre) history zone either.

Chris

 

by: patrickabPosted on 2008-09-17 at 01:17:31ID: 22496491

At 18 the pc was yet to be invented. At 22 I used a desktop electric calculator, a Burroughs tabulator (very unreliable), a monster computer or more often than not a slide rule and Stats/Log tables. As for a typewriter, I didn't even use one, let alone let alone own one. I was more au fait with a metalworking lathe than a keyboard.

 

by: chris_bottomleyPosted on 2008-09-17 at 08:17:22ID: 22499663

OK, I was a bit premature, at 15 the desktop electronic calculator, (add/subtract/divide/multpily) appeared in a few select locations, the computing course needed the monster computer at ICI and then at about 21 fantastic machines like the Microtan 65 started to appear ... but they required more Shekels than I could command!

I don't think even this puts me in your bracket though Patrick :o)

Chris

 

by: byundtPosted on 2008-09-22 at 06:52:07ID: 22539945

Happy birthday Jaes!

We don't see you as much in the threads, but it is always a pleasure when you do post.

Brad

 

by: roryaPosted on 2008-09-22 at 07:42:13ID: 22540427

Many happy returns, Jaes (meaniing both returns here and of the day!)

Rory

 

by: brettdjPosted on 2008-10-06 at 14:32:26ID: 22654597

As I sit here having watched the Dow gyrate wickedly in the last few hours I'm feeling a little relieved - as relieved as you can be when the world's biggest market just giave up 3.5%. But compared to the 7% plus slump not too much earlier, it's almost a win.

Any of you guys follow the market closely? The scale of the bank bail-outs and investment bank implosions is almost beyond comprehension. Till now I've been viewing this as a window of investment opportunity, but we seem to be moving to a place where the glue that holds the banking industry together is coming unstuck. It is truly soberingly remarkable.

Cheers

Dave

PS ... Patrick AB, sent you an email re catching up last week but we have continued our fine tradition of missing each other. Next week perhaps

 

by: zorvekPosted on 2008-10-06 at 14:41:15ID: 22654658

It's the institutions playing games with themselves. Long term everything will be fine and there are bargains but be careful. There are no rules stating that a bargain today won't be more of a bargain tomorrow. If you buy with a five plus year horizon you will be fine. Europe looks to be in more trouble since they don't have any real centralized set of controls yet are sharing the Euro. Another way to look at things is that just about every financial institution that is in trouble is getting bought by other institutions that were not so risk prone. The real losers are the stockholders of the failed institutions. The markets are dropping in general as investors switch to metals and other instruments less likely to have adverse reactions to tightening credit markets.

All good fun.

What is really a hoot is to see our boy George get up and try and 'splain the mess to us. Good fodder for the comics.

 

by: brettdjPosted on 2008-10-06 at 15:11:20ID: 22654878

Until now I thought we were seeing a financial sector specific contagion,and that largely the financial excesses were coming back to bite those who misunderstood or simply gambled on exotic securitisation.

> markets are dropping in general as investors switch to metals

That's what does scare me,  comoddities prices - sans Gold - are plummeting. Which should only be happening in a rational market if the BRIC growth story is in trouble. Hopefully this debt driven market is irrational .....

George does provide some light relief.


 

by: zorvekPosted on 2008-10-06 at 15:21:40ID: 22654952

Maybe the cash is going into the mattress versus metals...who knows. Asian stocks and real-estate in China and India seem to be hot commodities.

 

by: matthewspatrickPosted on 2008-10-06 at 15:24:09ID: 22654972

Kevin said:
>>Long term everything will be fine and there are bargains but be careful. There are no rules stating that a bargain
>>today won't be more of a bargain tomorrow. If you buy with a five plus year horizon you will be fine.

Generally, I agree with Kevin, with some qualifiers...

1) I do not bother trying to identify bargains.  To put it simply, there is *no evidence* that professional fund managers
have a repeatable talent for beating market indexes, once you properly account for transaction costs, management
fees, and the impact of taxes.  (Active management tends to drive up capital gains taxes, compared to low-turnover
funds such as indexes.)  I put my money into broad index funds with the lowest expense ratios I can find.  Don't
even bother with mentioning Warren Buffett: the laws of probability tell you that if you get enough millions of people
investing, you are practically guaranteed to see a Warren Buffett come along.

2) Read 'Stocks for the Long Run' by Jeremy Siegel, a legendary professor at my alma mater, the Wharton School.
In a 1-year period, it's easy to lose money on stocks.  As the term expands, however, the likelihood of a negative
cumulative returns from stocks (assuming dividend reinvestment) goes down.  Siegel plotted the likelihood of losing
money over various holding periods based on historical performances.  For the real long term investors, take heart:
since 1802, there has never been a 20-year period in which US stocks have lost money.  (Indeed, Siegel finds that
over long holding periods, not only do stocks outperform bonds, they are also less risky, using variance in annual
returns as the standard measure of risk.  This is a counter-intuitive finding, because it turns the old risk-reward
trade-off on its head.)

3) Do not, do not, DO NOT try to time the market.  No one has a crystal ball that tells them when the lowest low
has come (time to buy!) or the highest high (time to sell!).  Instead, figure out what your 1-year, 5-year, 10-year,
20-year, etc. needs are and make a rational plan for how to get there.  If your plan calls for you to invest, say,
$15,500 this year (the regular limit for 401(k) contributions in 2008, so a good benchmark), do not invest it all
at once.  Instead, invest say 1/12th of that amount each month.  If you are planning to sell (perhaps because
you have to take a mandatory distribution from an IRA, or to rebalance your portfolio), try not to sell the whole
block at once; spread it out over a few months.  The fancy term for this is "dollar cost averaging".  Do not even
bother with looking at the day to day price movements--it'll just make you more emotional and less rational.

4) Pay attention to asset allocation, and match asset allocation to when you need your money and your own
risk tolerance.  For example, if I needed a sum of money in five years, I wouldn't bother with stocks--I would
go with a mix of cash/cash equivalents like CDs and bond funds.  OTOH, for my retirement accounts, I am
100% in stock funds.  (Being 37, I have the luxury of at least a 30 year time horizon.  As I near retirement age,
I will start moving some of that into bond funds.)  Check your portfolio at least once a year to make sure that
differential returns haven't skewed your asset allocation.

5) Diversify, diversify, diversify.

 

by: patrickabPosted on 2008-10-06 at 15:35:08ID: 22655027

Be under no illusion, every part of the world will be affected. China and India will be no exception. The inter-dependance of the world's commercial and financial scene will ensure that everyone will feel the effect - obviously some more than others. The closer one is to the centres of financial greed the worse it will be.

 

by: zorvekPosted on 2008-10-06 at 15:59:01ID: 22655199

>The closer one is to the centres of financial greed the worse it will be.

Why does that sound so good to me?

 

by: brettdjPosted on 2008-10-07 at 01:12:15ID: 22657328

Thx for you comments Patrick. Broadly I agree with them other than I choose to be an active direct investor in stocks given my background and day job

My take is that if you are not leveraged then this is a buying opportunity.  Those with margin loans are forced sellers which is adding to the distress/volatilit

But when I look at my sector, and see a debt free iron ore company with long term price contracts trading at 2-3 times earnings then it's a "huh?" moment. And when I hear that the Australian Reserve has slashed interest rates by 1% in a single go then we are indeed living in "interesting" times.

 

by: brettdjPosted on 2008-10-11 at 11:03:16ID: 22694802

Changing the tone a little

Patrick ..... just how often do you called Matthew? My guess is 3 times a week. Am I close?

Dave (aka Brett)


 

by: matthewspatrickPosted on 2008-10-11 at 14:26:23ID: 22695373

brettdj said:
>>Patrick ..... just how often do you called Matthew? My guess is 3 times a week. Am I close?

A week?  Sometimes it's at least that in a day :)

I'm used to it.  I had teachers in school who did it almost constantly...

 

by: brettdjPosted on 2008-10-11 at 16:04:08ID: 22695574

People are quite slapdash, my wife once got called Brett in an email

I worked in a group that included a
David Joseph
Andrew Graham
Your truly
David Heath

... it caused havoc

I have binned around 5 resumes when people have applied to me with Dear Brett. But normally it's worse on the phone, people hear Brett last and it sticks.

 

by: zorvekPosted on 2008-10-11 at 16:23:43ID: 22695619

So...Brett, Matt...what's for dinner?

 

by: brettdjPosted on 2008-10-14 at 03:26:59ID: 22710003

Here is an appetiser for Matt ...... can you pls assist with this Access question, I jumped in a little early with the "Excel like" approach, and consequently I think the question has sunk from sight.

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_23805231.html

 

by: zorvekPosted on 2008-10-14 at 09:44:09ID: 22713111

Now we have a drunken elf on the payroll.

 

by: chris_bottomleyPosted on 2008-10-14 at 09:57:43ID: 22713269

PAYroll ... ey what!

 

by: brettdjPosted on 2008-10-17 at 16:02:21ID: 22746160

Is it just me or have some of the newbies got attitude?

http://www.experts-exchange.com/Programming/Automation/Q_23825657.html#a22746065

 

by: saurabh726Posted on 2008-10-17 at 16:04:43ID: 22746169

Dave...

He is not a newbie he is 5 years old in EE...and its just that what i think he didnt understood kevin properly about what he is doing...and pasted the whole code...

Saurabh...

 

by: zorvekPosted on 2008-10-17 at 16:06:45ID: 22746177

Yep. A few showed up this week.

Saurabh, he didn't see my second post.

 

by: roryaPosted on 2008-10-17 at 16:16:02ID: 22746211

May not be a newbie, but still got attitude! ;)

 

by: saurabh726Posted on 2008-10-17 at 16:17:20ID: 22746215

Hmm Kevin can be.....

Agree with rory on that.. and hey rory where you have been...dont see you online much...whats keeping you so busy...is it your cat..??

 

by: zorvekPosted on 2008-10-17 at 16:19:17ID: 22746225

He's tired of trying to post before you, me, and Dave.

Probably shopping for strollers and diapers.

 

by: roryaPosted on 2008-10-17 at 16:20:36ID: 22746231

Combination of work and life. And sometimes a change of scenery is good to blow out the cobwebs. :)

 

by: roryaPosted on 2008-10-17 at 16:21:55ID: 22746236

I gave up trying to post before you long ago. Now I just try and distract you with irrelevant arguments so that others can have a go! :^P

 

by: zorvekPosted on 2008-10-17 at 16:23:20ID: 22746246

Ha!

That last one wasn't so irrelevant...I'm working through my code putting in variables for forms.

 

by: saurabh726Posted on 2008-10-17 at 16:25:51ID: 22746255

Hmm rory...i guess you seriously got bored...thats why looked for change...that you got completely disappeared...

and you know what nothing works on kevin...no matter how much you keep him busy in something or other...he just manages to post before you do...and i wonder how does he manages to do that...

 

by: roryaPosted on 2008-10-17 at 16:25:53ID: 22746256

It's late - I mean irreverent, not irrelevant! ;)
It's obviously not working anyway as you're only 32,000 away from being able to finally put 'Savant' after the 'Idiot' in your title. 8^D

 

by: roryaPosted on 2008-10-17 at 16:28:03ID: 22746263

Saurabh,
I didn't completely disappear - just nothing like as active recently. It happens from time to time! :)

 

by: saurabh726Posted on 2008-10-17 at 16:29:41ID: 22746273

Hmmm ahh i see..and hey you had a boy or a girl.....?? and congrats for the newborn...party time...

 

by: zorvekPosted on 2008-10-17 at 16:30:46ID: 22746276

You Brits can really be a hoot!

May you have many sleepless nights come January ;-)

 

by: roryaPosted on 2008-10-17 at 16:31:26ID: 22746282

Neither yet! Not due until January.

 

by: roryaPosted on 2008-10-17 at 16:32:36ID: 22746290

You can imagine how long I've been waiting to make that "joke"! ;)

 

by: saurabh726Posted on 2008-10-17 at 16:36:49ID: 22746309

Ahh i see...now no wonder thats why you not here.... anyways all the best to you...and me surely misses you since its not fun when you are not posting much... because when you are arround i need to make sure i have to be quick...but these days dave is there to ensure that... and kevin like always is here....

 

by: zorvekPosted on 2008-10-17 at 16:40:48ID: 22746328

With Rory it's not about being quick, it's about posting crack solutions that make our stuff look like shit. Like Brad he loves to do that.

 

by: roryaPosted on 2008-10-17 at 16:42:06ID: 22746333

Be careful what you wish for - I'll be back trying to hoover up all the questions soon enough!

 

by: roryaPosted on 2008-10-17 at 16:43:03ID: 22746336

It's true - some of my solutions do look like I'm on crack.

 

by: zorvekPosted on 2008-10-17 at 16:44:21ID: 22746342

Right. And you can afford three nannies, a cook, a laundry maid, and a couple of house cleaners. Oh, and a few gents to take the lovely Mrs. Rory to dinner and a show now and then.

 

by: saurabh726Posted on 2008-10-17 at 16:44:49ID: 22746348

Kevin i agree with you over that...apart from yours i need to get there knowledge base as well....

And nah you not gonna be back soon...attleast for couple of months because you are busy..and even if you are back..its fun..because...there is lot of learn from you....

 

by: saurabh726Posted on 2008-10-17 at 16:46:17ID: 22746352

Hey Kevin...i can afford all the three nannies out here in India...its really cheap...we already have a maid to do the cleaning job...which comes daily...and she charges as less as $15 dollars for the month...

 

by: zorvekPosted on 2008-10-17 at 16:47:10ID: 22746360

>It's true - some of my solutions do look like I'm on crack.

Oh, that's good. The dudes on crack are Saurabh and me as we frantically toss crap on the walls 23.5 hours a day hoping something doesn't get a compile error and that the other guy is taking his daily nap.

 

by: zorvekPosted on 2008-10-17 at 16:48:40ID: 22746370

Which is why you have 18 hours a day to play video games and post on EE. We need to find you a girlfriend.

 

by: roryaPosted on 2008-10-17 at 16:49:15ID: 22746375

>>Oh, that's good. The dudes on crack are Saurabh and me as we frantically toss crap on the walls 23.5 hours a day hoping something doesn't get a compile error and that the other guy is taking his daily nap.

Right, like either of you sleep for that long in a day. :)

 

by: brettdjPosted on 2008-10-17 at 16:50:30ID: 22746380

LOL - i love it!

 

by: saurabh726Posted on 2008-10-17 at 16:52:43ID: 22746386

Kevin...you forgot love to watch movies as well..i got close to collection of 500+ dvds...talk about a movie and i have that....

and yes about the crack i agree...because see this guy...prasad..im gonna kill him one day for sure...he has 8 pending questions to be closed and all of them have answers been done...and already asked him about it..but still no action... next time i find his question...im gonna make sure he closes his earlier ones before this one gets resolved...this the link about what i meant...

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_23812992.html

and a gf for me...hmm i dont want one...anyways my parents looking for a match for me..may be by next year...

 

by: roryaPosted on 2008-10-17 at 16:53:29ID: 22746393

I'm trying to resist making an awful pun about getting some Preparation H to help with your compiles.

 

by: saurabh726Posted on 2008-10-17 at 16:56:00ID: 22746406

Guys i need to ask you something....its like the old xbox 360 ones which are non falcon ones...is there any good way arround for ring of death...because mine shows ring of death after every 2-3 weeks..and already have got it repaired thrice...and this the fourth time i has gone for repairs...

 

by: roryaPosted on 2008-10-17 at 16:56:54ID: 22746410

And on that note, I'll get my coat. Later, propellor-heads. :)

 

by: zorvekPosted on 2008-10-17 at 18:44:51ID: 22746698

I don't do games...sorry. Last time I played a game was Myst and I was AWOL for two weeks. Never do that again.

 

by: webtubbsPosted on 2008-10-18 at 19:49:17ID: 22750756

Can someone with xl2007 take a look at this question?

http:/Q_23827026.html

Wayne

 

by: brettdjPosted on 2008-10-21 at 14:56:59ID: 22771901

 

by: zorvekPosted on 2008-10-23 at 09:06:27ID: 22787684

 

by: brettdjPosted on 2008-10-23 at 09:14:04ID: 22787791

I like that formula almost as much as I hate Date questions. And that's a lot of like.

It would be interesting to see if he could pose another solution to http://www.experts-exchange.com/Q_23835174.html

 

by: zorvekPosted on 2008-10-23 at 09:40:18ID: 22788056

Yep. Only problem is he is not being very social...yet. We like social, don't we :-)

 

by: roryaPosted on 2008-10-23 at 09:50:42ID: 22788170

Barry is VERY good with formulas!

 

by: byundtPosted on 2008-10-23 at 10:11:10ID: 22788376

Barry is a Mr Excel MVP. He is also active on OzGrid and ExcelForum.

 

by: zorvekPosted on 2008-10-23 at 10:19:58ID: 22788476

That formula is impressive, but it is also pretty well spread around the web. Although I have not seen that trick before myself (or did and forgot which is more likely), the "=SUM(INT((WEEKDAY(" business is used to do a lot of different date tricks.

 

by: patrickabPosted on 2008-10-27 at 02:01:05ID: 22810786

Not been ignoring you all - just been away in China for the last 17 days.

Dave and Patrick M - I can't recall being called Matthew.

 

by: matthewspatrickPosted on 2008-10-30 at 06:51:52ID: 22840867

All,

Anyone feeling qualified to comment on integrating Access and Excel, please have a look at my question here:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23861610.html

Thanks,

Patrick

 

by: patrickabPosted on 2008-11-04 at 03:28:16ID: 22875193

Dave,

Quick check of emails - when you have a moment.

Patrick

 

by: zorvekPosted on 2008-11-04 at 21:45:12ID: 22883361

Hey, boys and girls, another party:

   http:Q_23875657.html

 

by: zorvekPosted on 2008-11-05 at 17:40:57ID: 22891792

I have an amendment to an earlier observation I made about Barry's post here:

   http:Q_23839939.html#a22787305

I now have it on first hand authority that the "=SUM(INT((WEEKDAY(" technique was created and first published by Barry himself. He has informed me that he will be a little more forthcoming with his real self in the very near future. In fact, I believe he has a kitty...or a wry sense of humor...or both:

   http:Q_23880102.html#a22891518

Kevin

 

by: roryaPosted on 2008-11-06 at 00:09:39ID: 22893026

Dude, I think you have abandinment issues. ;)

and FYI, Barry Houdini is not his real name. It's Larry. :)

 

by: zorvekPosted on 2008-11-06 at 00:39:11ID: 22893123

Right. And my real name is Dick.

When Barry tells me his name is Larry or Harry or Bubba then I'll change my notes. Until then it's Barry. Even Barry thinks it's Barry.

Abandonment issues? Wishful thinking on your part maybe. I do miss you but Saurabh keeps me very distracted these days. The only abandonment related issue I have is with regard to the poignant absence of normal Excel menu bars.

 

by: brettdjPosted on 2008-11-06 at 00:52:41ID: 22893185

Patrik AB - got it, will reply to you today post my morning meetings

 

by: roryaPosted on 2008-11-06 at 00:54:44ID: 22893191

Oh dear - have you upgraded then? (and I use 'up' in the loosest sense)

 

by: zorvekPosted on 2008-11-06 at 01:02:24ID: 22893217

Ha! (that's hehehehe in the land of chicken tikka.)

I run 97 though 2007 concurrently on all my boxes.

I was kidding - as I usually do - I'm so lost in 2007 that I keep my default association set to run 2003. I even have a .bat script on my desktop to reset that association whenever 2007 tries to take it back.

Ribbons (the non-configurable kind) and no VBA in Mac Office 2008! What were they thinking!

 

by: roryaPosted on 2008-11-06 at 01:24:46ID: 22893311

I think the only purpose of the Office 2008 release was to give 2007 users something to feel better about. ;)

 

by: brettdjPosted on 2008-11-06 at 02:35:38ID: 22893603

> I even have a .bat script on my desktop to reset that association whenever 2007 tries to take it back
Excellent, I'm being driven mad by 2007 opening by default.

Now Saurabh .. how about a follow-up to Kevin's hyperlink. And I don't want to talk about cricket.

 

by: zorvekPosted on 2008-11-06 at 02:51:49ID: 22893668

.bat:

"C:\Program Files\Microsoft Office 2003\OFFICE11\EXCEL.EXE" /RegServer

Pretty simple, really.

Yes, Saurabh, just what is the story?

[ducking and running for cover...]

 

by: barryhoudiniPosted on 2008-11-06 at 11:00:44ID: 22898311

Thanks Kevin,

I'm a little embarrassed really, I shouldn't be so protective of those formulas, I've half-inched a few in my time...........

As for the name, I did suggest (in jest) one time that my real name was Larry. It isn't. I go by the pseudonym "daddylonglegs" in a couple of places........

Given that Rory seems to be spending much of his time at MrExcel these days, I thought I'd engineer an exchange deal, you get me instead..........sorry!

Still, that's enough about me, what's happening in the real world?

 

by: zorvekPosted on 2008-11-06 at 11:25:02ID: 22898549

>I shouldn't be so protective of those formulas

Is there any possibility you CAN be protective? Once we post our magic that's the end. After that it's just our word against all the other Excel jocks out there. Put another way, in the past I've thought I had created some little unique nuggets only to find out later that Bob or Shane or Chip or Dick or some other jock already posted the same a year before. All good fun.

>I did suggest (in jest) one time that my real name was Larry. It isn't.

Ha! Take that Rory! Rory, like me, is a sucker for misinformation. I've been had a number of times. But the good news is you have a sense of humor. Here is an example of Rory's:

   http:Q_23509410.html#a21851394

Not too bad for someone who doesn't even know what his job title means.

>I thought I'd engineer an exchange deal, you get me instead..........sorry!

No apology necessary. Rory was getting on our nerves anyway with his silly fish n' chips humor and abusive use of the word "dude". Wait, you're a Brit too! Yikes! Patrick (AB), Nigel (but he's a ghost), Geoff (probably being held at gunpoint somewhere), Chris, Dave (pretending), Rory, and now you. Don't we have hiring quotas?

>Still, that's enough about me, what's happening in the real world?

Sorry? I don't understand.

 

by: saurabh726Posted on 2008-11-06 at 12:55:20ID: 22899443

Dave..

The hyperlink...what about that buddy...i just liked her...and asked Kevin who is she..since i liked her...and thats about it....

Kevin...

What story..??

 

by: zorvekPosted on 2008-11-06 at 18:22:43ID: 22901564

The story you just told. Stories don't need to be long, just entertaining. And, yes, that's entertaining considering the usual droll gunk that is posted here every day.

 

by: brettdjPosted on 2008-11-07 at 00:34:14ID: 22902565

Saurabh,

Just pulling your leg. :)

I'm ready to talk cricket now ...

Cheers

Dave

 

by: roryaPosted on 2008-11-07 at 02:54:24ID: 22903241

Barry/Larry/Harry,

I think I've seen daddylonglegs at excelforum.com? Another one to watch out for... :)

Rory

 

by: roryaPosted on 2008-11-07 at 03:37:08ID: 22903416

Kevin,

Why/how are you following me? What does it mean - it sounds creepy! :)

Rory

 

by: matthewspatrickPosted on 2008-11-07 at 05:11:19ID: 22903938

rorya said:
>>Why/how are you following me? What does it mean - it sounds creepy! :)

It's a new feature EE just rolled out.  Kevin is following you because he thinks he might learn something :)

Patrick

 

by: roryaPosted on 2008-11-07 at 05:35:13ID: 22904089

He might - but it won't be anything useful! :)

Ah, I've finally got my very own stalker...

 

by: matthewspatrickPosted on 2008-11-07 at 05:39:53ID: 22904127

rorya said:
>>Ah, I've finally got my very own stalker...

Just be glad it's not keilah or bsharath :)

 

by: brettdjPosted on 2008-11-07 at 05:40:40ID: 22904139

"We need to talk about Kevin"  ........

 

by: roryaPosted on 2008-11-07 at 05:43:34ID: 22904161

>> Just be glad it's not keilah or bsharath :)

I miss the old days when you could see the poster's name before you bothered reading a question. With those two it's just Click, "oh", Back. (though I can usually tell sharath's from the title!!) :^P

 

by: webtubbsPosted on 2008-11-07 at 05:48:43ID: 22904209

>>though I can usually tell sharath's from the title!!

or the duplicate questions!

 

by: matthewspatrickPosted on 2008-11-07 at 06:03:39ID: 22904323

>>I miss the old days when you could see the poster's name before you bothered reading a question.

That's just one reason why I always use QuickEE :)

 

by: roryaPosted on 2008-11-07 at 06:07:30ID: 22904363

I can't at work though...

 

by: webtubbsPosted on 2008-11-07 at 06:11:20ID: 22904396

Patrick - you should try EE Tools. Only available to those with the privs, but it has many of QEE's features and is far less prone to errors when EE changes something.

 

by: zorvekPosted on 2008-11-07 at 08:13:40ID: 22905753

Rory, you need to take the IT dude out to lunch and get the proxy server address and password. Get that and you are all set.

Wayne, why do you think Rory can't use the tool at work? Are not all the requests HTTP?

Yes, I'm a stalker. I'm trying to figure out what this new feature means and how it works. Rory, how did you find out I was stalking you? Email? What else do you see?

 

by: matthewspatrickPosted on 2008-11-07 at 08:18:18ID: 22905796

Kevin,

I don't think they are email notifs when someone starts following you.  However...

1) If a member is following you, it shows up on your profile
2) "Badger" types like Admins, Mods, and ZAPEs can follow in stealth mode, so you don't know they're following
you (unless you have similar privileges)
3) You can block a member who is following you (but you cannot block a "badger"--you may think you've blocked
the badger, but they're still following you)

 

by: brettdjPosted on 2008-11-07 at 08:18:54ID: 22905808

..... can we get a new thread. I'm getting RSI.

 

by: roryaPosted on 2008-11-07 at 08:29:33ID: 22905946

Doesn't QuickEE involve some sort of installation? That's what I can't do. I'll just carry on pressing f5 like a loon.

I saw you in my profile - didn't think it was very subtle stalking!

Dave - God yes - this one takes *ages* to scroll thorugh on my phone!! :)

 

by: zorvekPosted on 2008-11-07 at 08:31:36ID: 22905965

I'll start the new thread.

So all the "follow" function really does is provide a quick search function. That doesn't seem like much value to me - especially considering that the real search function should be fixed soon. Or do any of you think it should be anything more than what it is? Options to be notified?

Time to ping J.

 

by: brettdjPosted on 2008-11-07 at 08:39:43ID: 22906097

Wayne - a dumb question

Where do I get EE Tools so that I can keep up with my Indian friend (who I secretly suspect is a coke/caffeine/ice addict)

Patrick, I'd forgotten all about the badgers! I must get back to the lounge

 

by: zorvekPosted on 2008-11-07 at 08:43:20ID: 22906148

>I must get back to the lounge.

NOOOOOOOOOO!!!!!!!

>Where do I get EE Tools

http://quickee.dabas.net.au/publish.htm

 

by: brettdjPosted on 2008-11-07 at 08:49:34ID: 22906216

thx for the link

Are there any right wingers left in the lounge these days?
Not to mention Shek v BSOD,   CobolDinosaur v EE ......

 

by: zorvekPosted on 2008-11-07 at 08:51:00ID: 22906233

Continued here: http:Q_23885760.html

20120131-EE-VQP-002

3 Ways to Join

30-Day Free Trial

The Experts

98% positive feedback on 31,087 answers since March 2000. angeliii is a Microsoft Most Valuable Professional for his work with MS SQL Server & Develoment.

He has also proven his knowledge of Visual Basic Programming, PHP Scripting and Oracle Databases.

The Experts

97% positive feedback on 10,752 answers since July 2000. lrmoore has more than 18 years experience in the networking industry.

The six-time Mircosoft MVPs specialties include firewalls, virtual private networking, and network management.

Testimonials

"...and excellent source for support... Kind of like having your very own IT dept." Electriciansnet

Testimonials

"I was apprehensive at signing up at first. However... it has already made my life as an IT administrator much easier." JaCrews

Testimonials

"WOW! You guys have great, active, and knowledgeable people on here." moore50

Business Clients

Business Clients

In the Press

"If you’ve got a question... Experts Exchange can supply an answer.”

In the Press

"...an invaluable aid for both IT professionals and those who require tech support."

In the Press

"where IT professionals provide quick answers on just about any topic"

Business Account Plans

Loading Advertisement...