I wish to build the database which will get the url from user in a single cell and returns some texts towards the other cells. The Url comes from www.imdb.com . I first viewed it was possible on the internet Spreadsheet. I'm wondering whether it's feasible for MS Stand out.
Like after i input a film Url, it will get rankings,title, casts from IMDB page.
Thanks ahead of time
You will get pretty close utilizing a IQY file to define the net query and also the parameters a person should input. The only real difference is the fact that, instead of determining the film id inside a cell, your user is going to be motivated once they create or refresh a question.
To get this done, you have to:
- produce a plain text iqy file. Refer to it as "imdb-movie.iqy" or something like that.
- Put this text inside it:
WEB 1 http://www.imdb.com/title/["Movie ID"]/ Selection=3 Formatting=None PreFormattedTextToColumns=True ConsecutiveDelimitersAsOne=True SingleBlockTextImport=False DisableDateRecognition=False DisableRedirections=False
- Within the "Get Exterior Data pane from the Stand out Data ribbon click "Existing Connections" and discover your IQY file. It'll request you where you can place the data and prompt you for that movie id. By right clicking, you can observe plenty of configurations about formatting and the like.
The "selection=3" entry within the IQY file determines what table to drag the information in from. It may sound like you might want many of them.
To create your personal IQY file, you are able to pick the "get exterior data/from web" and choose which table to make use of. Then choose "save" in the dialog and you've got the file. You are able to paramaterize it using the ["parameter title","prompt"] syntax.
Yes, you could do, and can require substantial VBA programming effort to get it done.