Recent content by RodP

Fantastic idea, Thanks again for your all your help RodP

Hi Tsuji Thanks very much for this. in a word, doh! I also noticed that I needed to get rid of the line .add "Title","" One more thing, I've made the ie object invisible but whilst running, the focus on whatever window i'm working on is lost. I have to keep alt+tab'ing back into it...

Hi tsuji, Thanks for the alternative method - never really used while and loop before. I assume then that goto doesn't really work in vbscript? I've amended the code but there's one other difference between running the code in excel and vbscript. set varTitle = oie.document.all.tag("TITLE")...

Hi Tsuji, Thanks very much for the help and the code, that's really helped me. This is the code I have so far. I've put a loop in it and now need to put some error checking as sometimes the web addresses used bring up an unavailable / error page. This is a little sporadic and so I wanted...

Hi Caution MP, Fantastic bit of code! This is what I've been looking for, for ages. However, is there a way to write the code into a csv file rather than an hmtl file as I want to cycle thorugh a number of identical webpages and append the info The webpage in question is...

Hi Everyone, Can you help / advise as I'm not too sure what search terms / terminology to use when trying to find a program / some script to help me. I have a website: http://www.mysupermarket.co.uk/Shopping/ProductDetails.aspx?Product=11498&Store=1 in which I want to grab (parse?) the...

Hi feherke, oops - yep - java script or vb script is what I'm looking for. Thanks for the link. I've had a go using it but struggling a little using it. -I've tried to build a filter using filterbuilder in the BIN directory but I don't think it's going to ultimately make a csv file out of...

Hi Everyone, Can you help / advise as I'm not too sure what search terms / terminology to use when trying to find a program / some script to help me. I have a website: http://www.mysupermarket.co.uk/Shopping/ProductDetails.aspx?Product=11498&Store=1 in which I want to grab (parse?) the data...

Hi Everyone, Please could someone help me... I have a program called 'Akti Album'. It uses an xml format to store the data in order to create a simple image library website. The GUI doesn't allow you to import data and so you have to type in each record manually. I have about 600 records to...

Hi Vroscioli, Cheers for that insight. Will amend my code accordingly. Many thanks RodP

Hi xlbo, Thanks for this. Do you know where I can get a full listing of what %xx values mean what? Thanks RodP

Hi Everyone, I have a long list of hyperlinks for which i have converted into text to get hold of the filenames (for example). However, like normal internet addresses, you can't use certain characters and so they are replaced with other characters. eg: What%27s on Weetabix.mpg...

Hi Xlbo, Thanks for the note and I've now found some other info... http://www.ozgrid.com/forum/showthread.php?t=26905 It looks like maybe in 2003 it's been sorted but a way to get round it is as you suggest run the .find procedure from a sub. I'll have a go at moving at setting up a funciton...

Hi Xlbo This is very interesting. I'm using excel 2000. Are you perhaps using a newer version? I tried your latest code but it still returns 0 in the cell. 'c' is still nothing. I'm putting the code into a normal module within the same workbook to test it. Any ideas? Thanks RodP

Hi Xlbo, Unfortunately, your version doesn't work either. 'c' remains to be nothing after the '.find...' bit. Any suggesitons - or should I go back to using the 'instr' method - any suggestions on speeding that up? Many thanks RodP