Search results for query: *

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

Hi Xlbo, Thanks for the tip and I presume that using 'find' will speed things up. I've found the example in the help but am having problems. I think it's due to my lack of understanding of objects. Can you help? This is my code which doesn't want to work / just returns zero in the cell where...

Hi xlbo, The function will look for multiple instance. It works a bit like a vlookup forumla but returns the offset value of more than one instance. Really good to find whether an item in some data exists in say more than one category. eg. Item1 Category1 Item2 Category1 Item3 Category1...

Hi Everyone, I've put together a function in excel that will provide multiple search results from an array and can be based on multiple search criteria. Plus you can return a value that is offset to the location the value in question was found. However it works rather slowly and so would be...

Hi Pascal, No, I was trying to use an @command in a formula for a column in a design view called 'all documents (2)', not an agent. Hope this clarifies things thanks Rodp

Hi pmonett, It says '@command and other UI functions are not allowed in this context'. It sounds like I can't use the @command. Plus also, I now can't get back into the design of it as when ever I click on it it gives this error and jumps back to the previous view i was in. Annoying!! Do...