Click here to Skip to main content
15,914,222 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: SiteMapPathProvider Pin
Tarik Guney29-Apr-07 10:50
Tarik Guney29-Apr-07 10:50 
AnswerRe: SiteMapPathProvider Pin
szukuro29-Apr-07 11:33
szukuro29-Apr-07 11:33 
GeneralRe: SiteMapPathProvider Pin
Tarik Guney29-Apr-07 11:50
Tarik Guney29-Apr-07 11:50 
GeneralRe: SiteMapPathProvider Pin
szukuro29-Apr-07 13:37
szukuro29-Apr-07 13:37 
GeneralRe: SiteMapPathProvider Pin
Tarik Guney29-Apr-07 23:52
Tarik Guney29-Apr-07 23:52 
QuestionProblems regarding printing ? Pin
sdklfjlkdsfjdklsfjkdslfjdslkf29-Apr-07 8:46
sdklfjlkdsfjdklsfjkdslfjdslkf29-Apr-07 8:46 
AnswerRe: Problems regarding printing ? Pin
Christian Graus29-Apr-07 12:23
protectorChristian Graus29-Apr-07 12:23 
Questionimport data from another web site / import html table to excel . Pin
hen10029-Apr-07 8:42
hen10029-Apr-07 8:42 
Hi,
I am a beginner in the area and have some questions regarding importing of data from another web page, and importing table from html to excel.
I guess vbscript is related to ASP, so I hope its ok to post here...
Anyway, I'll just describe my application:
Lets say this web site I need to download tables from is www.cnn.com
Inside this site lets say there are 10 links to internal pages, and in those pages there are the tables I need (besides many text that I don't).
I need to download all the tables from those internal pages to excel. I would like to have a macro button in excel that will create a new sheet with all that data.
I saw that if I just copy the html code between .....
and just rename it in a new word pad file X.xls, and open it, I get almost a nice table in excel (almost - somehow with no grids between the cells of the entire sheet - dont know why).
Knowing that I can run a script (vbscript) to look for the string "table" and than copy all the data until the string , My problems are:
1) I write a script, but how do I call to a different web site, so my script will run on it?
2) Lets complicate: I know only the link to the index page (www.cnn.com), from there I need my script to look for all the tables inside the internal pages. (or all the tables, starting with a very specific word), and each one is on a different web page (different link). (do I write a loop which look for "href .... "? but how do I run over an entire html file (insert all between .... into a string? - that's too long...? I know there is " InStr" , but I guess it won't work in this case.
3) I want to copy between until
. Again, there is a lot of data between and string is a limited variable. How do I do that.
4) After fixing those two, how will I run my script from the excel (but this, I guess will be much easier)?
Thanks, I'll be thankful for any help.
Hanan.
QuestionGlobal.asax User Authentication Pin
DanB198329-Apr-07 7:40
DanB198329-Apr-07 7:40 
GeneralTake items from a Collection and write them to a XML Document [modified] Pin
Psycho-*Coder*-Extreme29-Apr-07 5:03
Psycho-*Coder*-Extreme29-Apr-07 5:03 
QuestionHow do you set a time delay for Response.Redirect() Pin
kinsella_john29-Apr-07 4:07
kinsella_john29-Apr-07 4:07 
AnswerRe: How do you set a time delay for Response.Redirect() Pin
kubben29-Apr-07 5:33
kubben29-Apr-07 5:33 
AnswerRe: How do you set a time delay for Response.Redirect() Pin
Guffa29-Apr-07 6:54
Guffa29-Apr-07 6:54 
GeneralRe: How do you set a time delay for Response.Redirect() Pin
kubben29-Apr-07 11:13
kubben29-Apr-07 11:13 
GeneralRe: How do you set a time delay for Response.Redirect() Pin
kinsella_john29-Apr-07 11:50
kinsella_john29-Apr-07 11:50 
GeneralRe: How do you set a time delay for Response.Redirect() Pin
Christian Graus29-Apr-07 12:24
protectorChristian Graus29-Apr-07 12:24 
QuestionUnable to validate data Pin
Maher Elsayed29-Apr-07 3:04
Maher Elsayed29-Apr-07 3:04 
QuestionNavigating one page to another page Pin
rajigopalan28-Apr-07 23:19
rajigopalan28-Apr-07 23:19 
AnswerRe: Navigating one page to another page Pin
Arun.Immanuel28-Apr-07 23:36
Arun.Immanuel28-Apr-07 23:36 
QuestionRedirect vs Transfer Pin
Tarik Guney28-Apr-07 22:55
Tarik Guney28-Apr-07 22:55 
AnswerRe: Redirect vs Transfer Pin
Guffa29-Apr-07 0:45
Guffa29-Apr-07 0:45 
QuestionVS2003 VS2005 debugging errors Pin
TheEagle28-Apr-07 22:54
TheEagle28-Apr-07 22:54 
QuestionAdding target to a button Pin
Tarik Guney28-Apr-07 21:57
Tarik Guney28-Apr-07 21:57 
AnswerRe: Adding target to a button Pin
yet_alive28-Apr-07 22:09
yet_alive28-Apr-07 22:09 
AnswerRe: Adding target to a button Pin
Guffa29-Apr-07 0:52
Guffa29-Apr-07 0:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.