Results 1 to 8 of 8
  1. #1
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Faking the 'Matrix' (excel 2003/sp2)

    For those that might be interested here is a link to my website http://www.webgenii.ca/ where I have a video of Matrix style screen display, that shows during a long stretch of data processing. Yes, it does add to the processing time but not that seriously.

    My strategy was to create styles in the code and apply them to the data as it is processing. Scrolling the screen continuously. At the end, I delete the styles and a plain worksheet with processed data is left.

    I thought it was a fun thing to try out.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  2. #2
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Faking the 'Matrix' (excel 2003/sp2)

    Hi Catharine

    The idea sounds really good, unfortunately I have tried 3 times to view the .avi but it just hangs for about 10 minutes and nothing, usually I can download a big clip in no time at all, I will have another go in the morning.

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Faking the 'Matrix' (excel 2003/sp2)

    A neat trick, but instead of just pointing the users to a video of the effect, I think it would be more useful to post a file on the board (or on your site) demonstrating the technique and perhaps describing it in more detail.

    Steve

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Faking the 'Matrix' (excel 2003/sp2)

    The only way I was able to view it, was to save it to my harddrive and then run it locally [It is a 33 Meg file]

    Steve

  5. #5
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Faking the 'Matrix' (excel 2003/sp2)

    Hi Catharine

    As Steve said it is a big movie (33meg) but I managed to get it this morning whilst my tea and toast were doing, it looks really good, well done

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Faking the 'Matrix' (excel 2003/sp2)

    I use a progress window like this one...
    Attached Images Attached Images
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  7. #7
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Faking the 'Matrix' (excel 2003/sp2)

    I think perhaps I was a bit over enthused when I set it up, I'll try and record a smaller movie file.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  8. #8
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Faking the 'Matrix' (excel 2003/sp2)

    Very Elegant, I usually have a progress bar or update the status bar with information. But I knew these guys would appreciate it, and I just wanted to see if I could make Excel do it.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

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