Consulting

Results 1 to 17 of 17

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

  1. #1
    Site Admin
    The Princess
    VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location

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

    Colo has developed what he calls

    an interesting add-in for Excel
    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

    Thanks, Colo!! It's toooo cool!!
    ~Anne Troy

  2. #2
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    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)

  3. #3
    VBAX Mentor XL-Dennis's Avatar
    Joined
    May 2004
    Location
    ?stersund, Sweden
    Posts
    499
    Location
    Yes, Colo do some nice work and he deserve all the credit for it

    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
    Kind regards,
    Dennis

    ExcelKB | .NET & Excel | 2nd edition PED


  4. #4
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    That looks pretty interesting. Good work Colo.

  5. #5
    VBAX Master TonyJollans's Avatar
    Joined
    May 2004
    Location
    Norfolk, England
    Posts
    2,291
    Location
    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.
    Enjoy,
    Tony

    ---------------------------------------------------------------
    Give a man a fish and he'll eat for a day.
    Teach him how to fish and he'll sit in a boat and drink beer all day.

    I'm (slowly) building my own site: www.WordArticles.com

  6. #6
    Site Admin
    The Princess VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    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!!
    ~Anne Troy

  7. #7
    VBAX Mentor XL-Dennis's Avatar
    Joined
    May 2004
    Location
    ?stersund, Sweden
    Posts
    499
    Location
    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
    Kind regards,
    Dennis

    ExcelKB | .NET & Excel | 2nd edition PED


  8. #8
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    But that doesn't mean not to have fun with it! :rofl

    I see your point though Dennis.

  9. #9
    BoardCoder
    Licensed Coder VBAX Expert mark007's Avatar
    Joined
    May 2004
    Location
    Leeds, UK
    Posts
    622
    Location
    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!

    "Computers are useless. They can only give you answers." - Pablo Picasso
    Mark Rowlinson FIA | The Code Net

  10. #10
    VBAX Regular
    Joined
    Jun 2004
    Location
    The Netherlands
    Posts
    34
    Location
    Looks nice but somehow it cannot find the dll for: SetLayeredWindowAttributes

  11. #11
    VBAX Master TonyJollans's Avatar
    Joined
    May 2004
    Location
    Norfolk, England
    Posts
    2,291
    Location
    What OS are you running? I think it needs Win 2K or NT/XP.
    Enjoy,
    Tony

    ---------------------------------------------------------------
    Give a man a fish and he'll eat for a day.
    Teach him how to fish and he'll sit in a boat and drink beer all day.

    I'm (slowly) building my own site: www.WordArticles.com

  12. #12
    VBAX Regular
    Joined
    Jun 2004
    Location
    The Netherlands
    Posts
    34
    Location
    that might be the problem. still on 98 with office 2000

  13. #13
    MS Excel MVP VBAX Regular Colo's Avatar
    Joined
    May 2004
    Location
    Kobe, Japan
    Posts
    23
    Location

    Thx all!

    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.

  14. #14
    VBAX Mentor XL-Dennis's Avatar
    Joined
    May 2004
    Location
    ?stersund, Sweden
    Posts
    499
    Location
    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/de...entid=28001169

    At least if I recall it right

    Kind regards,
    Dennis
    Kind regards,
    Dennis

    ExcelKB | .NET & Excel | 2nd edition PED


  15. #15
    VBAX Regular
    Joined
    Jun 2004
    Location
    The Netherlands
    Posts
    34
    Location
    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

  16. #16
    VBAX Mentor XL-Dennis's Avatar
    Joined
    May 2004
    Location
    ?stersund, Sweden
    Posts
    499
    Location
    Kind regards,
    Dennis

    ExcelKB | .NET & Excel | 2nd edition PED


  17. #17
    VBAX Regular
    Joined
    Jun 2004
    Location
    The Netherlands
    Posts
    34
    Location
    Dennis, thanks for the research! Now we have a good remark for Colo
    Jeroen

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •