Uh oh! Colo's Been at it Again!!

[Anne Troy]

Colo has developed what he calls


an interesting add-in for Excelhttp://www.puremis.net/excel/soft/EaZyRss.shtml (http://www.puremis.net/excel/soft/EaZyRss.shtml)


And you can read opinions on it here:
http://blog.livedoor.jp/colo_jpn/archives/5899937.html (http://blog.livedoor.jp/colo_jpn/archives/5899937.html)

Thanks, Colo!! It's toooo cool!!

[Zack Barresse]

Wow! Very cool! Although I don't know much about it, I could definitely see some good use coming out of that.

(Although I'm still trying to figure out what a blog is! LOL)

[XL-Dennis]

Yes, Colo do some nice work and he deserve all the credit for it :yes

With all the respect for his and other developer's works but I dislike the recent development of expanding Excel to cover all with add-ins and built-in features.

Next time someone develop an add-in for Excel it will propably reboot Windows, send an e-mail, check the latest post on the favourite newsgroups, schedule Your meetings and remind You to go to the dentist and alarm it's time to stretch and go to bed, transfer money, do some vacation-bookings and... The most challenging thing would be to instruct Excel to feed us.

What I mean is that Excel is a spreadsheet-software per se where we primarily work with numerical data (calculate, add-value, present and analyze). Sure, we need to import and export numerical data but that are part of the mainpurpose with Excel.

If I want to do other stuff I expect there exist lot of softwares that meet my demands in a professional way.

Sorry for being a pain.... but I sometimes feel a need to point out something I dislike.

Yeah, first time I admit that I'm old-fashioned :rofl

Take care,
Dennis

[Jacob Hilderbrand]

That looks pretty interesting. Good work Colo. :)

[TonyJollans]

Wow! That really is something else.

I do tend to agree with Dennis that it really has nothing to do with Excel, but it's a very nice piece of work all the same.

[Anne Troy]

I've been meaning to respond to Dennis' post since he made it.
And I fully agree.
Scott showed me an Excel "browser". Big deal?

I think the real message here isn't "LOOK WHAT EXCEL CAN DO"
It's "LOOK WHAT I CAN DO WITH EXCEL!"

And THAT is the very cool part!!

[XL-Dennis]

Anne,

I can agree with it as I know very well that both Ivan & Colo has this approach but unless it's explicit stated it leaves some unanswered questions for the broad audinece of end-users.

I?ve seen the developing for the last years and when also MS add "whistle & bells" but without any real contribution to Excel's mainpurpose then I start to wonder...

But it take some insight (which You have ;) ) to come to the conclusion You scream about ;)

Kind regards,
Dennis

[Zack Barresse]

But that doesn't mean not to have fun with it! :D :rofl

I see your point though Dennis.

[mark007]

I see your point Dennis for sure and know exactly what you mean. Personally I never have the ideas to even think of doing something like that really LOL


Next time someone develop an add-in for Excel it will propably reboot Windows, send an e-mail, check the latest post on the favourite newsgroups, schedule Your meetings and remind You to go to the dentist and alarm it's time to stretch and go to bed, transfer money, do some vacation-bookings and... The most challenging thing would be to instruct Excel to feed us.

I'd sure like a cpoy of this!

:)

[roos01]

Looks nice but somehow it cannot find the dll for: SetLayeredWindowAttributes

[TonyJollans]

What OS are you running? I think it needs Win 2K or NT/XP.

[roos01]

that might be the problem. still on 98 with office 2000

[Colo]

Hi All, thanks for your comments.

I agree with the Dennis's opinion, yea Excel is basically designed as a spread sheet soft ware.
So I didn't need to write the code in Excel VAB.(In fact, I wrote the code in VBS at first.)
As Dennis posted in the J-walk blog, I should have made it as a com-addin, but I just show Excel can do it. :-)
Since I did not protect the code, every users can look at the code, I think it helps.


roos01, I did not test that on Win 98..I must write about this as a note. Thanks for the input.

[XL-Dennis]

Hi CM Colo,



In fact, I wrote the code in VBS at first.

That?s nice ;)



I think it helps.

Yes.

Anyway, I took a look on the references and since You use MS VBScript Regular Expression 5.5 the end-users who has Win98 need to install Windows Script Host (WSH) which is available here:

http://msdn.microsoft.com/library/default.asp?url=/nhp/default.asp?contentid=28001169

At least if I recall it right ;)

Kind regards,
Dennis

[roos01]

Hi Dennis,
I downloaded the WSH but still the same problem. somehow/somewhere it is missing a dll.
I retrieve for the record the next message:
error 453
Can't find DLL entry point SetLayeredWindowAttributes in user32.

Jeroen

[XL-Dennis]

Hi Jeroen,

Hm, I made a research at MSDN and it seems it require Windows 2000:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/winui/WinUI/WindowsUserInterface/Windowing/Windows/
WindowReference/WindowFunctions/SetLayeredWindowAttributes.asp (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/winui/WinUI/WindowsUserInterface/Windowing/Windows/WindowReference/WindowFunctions/SetLayeredWindowAttributes.asp)

Kind regards,
Dennis

[roos01]

Dennis, thanks for the research! Now we have a good remark for Colo:)
Jeroen