Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. Web page question

Web page question

Scheduled Pinned Locked Moved The Lounge
questionphpcom
24 Posts 10 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • N netclectic

    Open Excel, go File -> Open, Paste in the URL

    7 Offline
    7 Offline
    73Zeppelin
    wrote on last edited by
    #9

    netclectic wrote:

    Open Excel, go File -> Open, Paste in the URL

    Apparently the document has moved....

    N 1 Reply Last reply
    0
    • N netclectic

      Open Excel, go File -> Open, Paste in the URL

      N Offline
      N Offline
      Nish Nishant
      wrote on last edited by
      #10

      netclectic wrote:

      Open Excel, go File -> Open, Paste in the URL

      :omg: Just tried it out! Awesome! Regards, Nish

      My blog : Nish’s thoughts on MFC, C++/CLI and .NET

      7 1 Reply Last reply
      0
      • B benjymous

        Yikes! I'd have never thought something like that'd work Scary! -- Help me! I'm turning into a grapefruit! Buzzwords!

        N Offline
        N Offline
        Nish Nishant
        wrote on last edited by
        #11

        benjymous wrote:

        Yikes! I'd have never thought something like that'd work

        Yeah, I was stunned too! Regards, Nish

        My blog : Nish’s thoughts on MFC, C++/CLI and .NET

        1 Reply Last reply
        0
        • N Nish Nishant

          netclectic wrote:

          Open Excel, go File -> Open, Paste in the URL

          :omg: Just tried it out! Awesome! Regards, Nish

          My blog : Nish’s thoughts on MFC, C++/CLI and .NET

          7 Offline
          7 Offline
          73Zeppelin
          wrote on last edited by
          #12

          Did it work for you Nish? I got a message telling me the document had been permanently moved...:confused:

          N 2 Replies Last reply
          0
          • 7 73Zeppelin

            netclectic wrote:

            Open Excel, go File -> Open, Paste in the URL

            Apparently the document has moved....

            N Offline
            N Offline
            Nish Nishant
            wrote on last edited by
            #13

            thealj wrote:

            Apparently the document has moved....

            No it hasn't, I tried it 1 minute ago and it worked. Regards, Nish

            My blog : Nish’s thoughts on MFC, C++/CLI and .NET

            1 Reply Last reply
            0
            • 7 73Zeppelin

              Did it work for you Nish? I got a message telling me the document had been permanently moved...:confused:

              N Offline
              N Offline
              Nish Nishant
              wrote on last edited by
              #14

              thealj wrote:

              Did it work for you Nish?

              Yes. I tried it again just to be sure. I used the following URL :- http://www.westernmininghistory.com/data/gold_production.php[^] Regards, Nish

              My blog : Nish’s thoughts on MFC, C++/CLI and .NET

              1 Reply Last reply
              0
              • 7 73Zeppelin

                Did it work for you Nish? I got a message telling me the document had been permanently moved...:confused:

                N Offline
                N Offline
                Nish Nishant
                wrote on last edited by
                #15

                BTW I use Excel 2003. Regards, Nish

                My blog : Nish’s thoughts on MFC, C++/CLI and .NET

                7 1 Reply Last reply
                0
                • N Nish Nishant

                  BTW I use Excel 2003. Regards, Nish

                  My blog : Nish’s thoughts on MFC, C++/CLI and .NET

                  7 Offline
                  7 Offline
                  73Zeppelin
                  wrote on last edited by
                  #16

                  It would appear that it does not work with Excel 2000. I did, however, fire up Quattro Pro 11 and it worked. Quite interesting, never knew you could use File->Open for a URL.

                  N N 2 Replies Last reply
                  0
                  • 7 73Zeppelin

                    It would appear that it does not work with Excel 2000. I did, however, fire up Quattro Pro 11 and it worked. Quite interesting, never knew you could use File->Open for a URL.

                    N Offline
                    N Offline
                    Nish Nishant
                    wrote on last edited by
                    #17

                    thealj wrote:

                    It would appear that it does not work with Excel 2000.

                    Maybe, that's it. Regards, Nish

                    My blog : Nish’s thoughts on MFC, C++/CLI and .NET

                    1 Reply Last reply
                    0
                    • 7 73Zeppelin

                      Is there any possible way to capture this[^] data table directly into Excel? Somebody please tell me yes...

                      R Offline
                      R Offline
                      Rama Krishna Vavilala
                      wrote on last edited by
                      #18

                      With excel 2003 you could capture and even refresh table automatically. 1. Select Data->Import External data->New Web Query 2. Type the URL of the website in the address field 3. Execl automatically allows you to select the table 4. Finally click on Import 5. Select the cells where you want to place the table. 6. You can refresh the data whenever you desire by clicking on refresh data

                      D 1 Reply Last reply
                      0
                      • R Rama Krishna Vavilala

                        With excel 2003 you could capture and even refresh table automatically. 1. Select Data->Import External data->New Web Query 2. Type the URL of the website in the address field 3. Execl automatically allows you to select the table 4. Finally click on Import 5. Select the cells where you want to place the table. 6. You can refresh the data whenever you desire by clicking on refresh data

                        D Offline
                        D Offline
                        Don Miguel
                        wrote on last edited by
                        #19

                        Good tip indeed! Thanks.

                        1 Reply Last reply
                        0
                        • 7 73Zeppelin

                          It would appear that it does not work with Excel 2000. I did, however, fire up Quattro Pro 11 and it worked. Quite interesting, never knew you could use File->Open for a URL.

                          N Offline
                          N Offline
                          netclectic
                          wrote on last edited by
                          #20

                          Excel 2000 here and it works fine.

                          7 1 Reply Last reply
                          0
                          • N netclectic

                            Excel 2000 here and it works fine.

                            7 Offline
                            7 Offline
                            73Zeppelin
                            wrote on last edited by
                            #21

                            netclectic wrote:

                            Excel 2000 here and it works fine

                            Very strange. It will not work for me under Excel 2000. It informs me that the document is no longer available. Quattro Pro, on the other hand, will perform the operation successfully.

                            1 Reply Last reply
                            0
                            • 7 73Zeppelin

                              Is there any possible way to capture this[^] data table directly into Excel? Somebody please tell me yes...

                              T Offline
                              T Offline
                              TheGreatAndPowerfulOz
                              wrote on last edited by
                              #22

                              start excel goto website select the table copy, paste into excel

                              D 1 Reply Last reply
                              0
                              • T TheGreatAndPowerfulOz

                                start excel goto website select the table copy, paste into excel

                                D Offline
                                D Offline
                                Dan Neely
                                wrote on last edited by
                                #23

                                ahz wrote:

                                start excel goto website select the table copy, paste into excel

                                Does this trick work in any browser besides IE? Opera, and FF don't do this.

                                T 1 Reply Last reply
                                0
                                • D Dan Neely

                                  ahz wrote:

                                  start excel goto website select the table copy, paste into excel

                                  Does this trick work in any browser besides IE? Opera, and FF don't do this.

                                  T Offline
                                  T Offline
                                  TheGreatAndPowerfulOz
                                  wrote on last edited by
                                  #24

                                  dan neely wrote:

                                  Does this trick work in any browser besides IE? Opera, and FF don't do this.

                                  hmm, dunno. you can open the website directly from the open file dialog of excel 2003 (and maybe 2000?) -- just type the url of the website in the filename box.

                                  1 Reply Last reply
                                  0
                                  Reply
                                  • Reply as topic
                                  Log in to reply
                                  • Oldest to Newest
                                  • Newest to Oldest
                                  • Most Votes


                                  • Login

                                  • Don't have an account? Register

                                  • Login or register to search.
                                  • First post
                                    Last post
                                  0
                                  • Categories
                                  • Recent
                                  • Tags
                                  • Popular
                                  • World
                                  • Users
                                  • Groups