Search results for query: *

Hi, I have created some javascript that reads data from a web page, creates an iframe with a form in it which autosubmits to a php page on another domain. This then returns some information to the original page using javascript's postMessage with an EventListener on the original page. This is...

OK, I have now resolved this. javascript: var win2=window.open("webpage.php"); var x = setTimeout("win2.top.document.forms[0].getElementById('message').value='123';",1000); Does indeed work fine. Thanks for the help.

Aha, now that makes sense. However, when I try using setTimeout it clears the parent window and puts a number between 1 and 4 on it. On clicking back on this page, it does the update. I now have: javascript: var a=window.open("webpage.php"); timeout =...

I have tried everything I can think of to put text in a textarea in a child window opened via javascript. I can't get it to work. However, someone else had a look at this and came up with (which does work): javascript: var a=window.open("webpage.php"); alert(a.top)...

I am using requestWriter to post to a website but as it takes ages for a response to come back, is there any way of sending the data and leaving it at that? I have tried removing the GetResponse parts but that doesn't seem to work. As the code stands (see below) it works fine but is too slow...

Ah! Sorry, wrong forum - this is VB 2005! Will post there instead.

I am using requestWriter to post to a website but as it takes ages for a response to come back, is there any way of sending the data and leaving it at that? I have tried removing the GetResponse parts but that doesn't seem to work. As the code stands (see below) it works fine but is too slow...

Hi Mike, By the looks of the data, it appears Copy1 couldn't see it's own changes it had just made as often data needs writing to the same record (but different fields) consecutively 6 or 7 times and there were up to 6 or 7 duplicates of some records and as there is no set order for the data...

Well, I have tried rmikesmith's idea and it seemed to help with the database locking problem (or at least this week it did as it tends to be a bit intermittent but hopefully it does) but there is a major problem with it!! If a record does not exist, the record is added, if it already exists...

PHV I think that will be of no use to me as Excel is doing all the work, Access is only holding the data. rmikesmith, now that's a thought. I originally wrote it to keep the connection open only for short periods when writing to try and avoid this type of problem as much as possible. I will...

Hi, I have an Excel spreadsheet which writes loads of data to an Access database and takes ages to run as most of the information is downloaded from tables on the internet. I have found that if I split the spreadsheet in 2 and run both copies at the same time with each doing half the work, it...

OK, ignore this question, I have sussed it!! It should be pic.Hyperlink.Address and then it works fine!!

Hi, I have a spreadsheet where I cut and paste a web-page to one of the pages and then strip data from it using VBA (the webpage won't let me import it using a web-query). On this page there are numerous pictures with hyperlinks attached. How can I get the hyperlinks from these pictures...

AMCCoder, that looks like it will work fine, thanks (wasn't aware of the CHRW and ASCW functions). Temporarily I was writing the text to a cell and then reading it back from another cell with a SUBSTITUTE formula in it which worked fine until Excel kindly loaded one of the webpages over it and...

the non-accented character (as previously stated) - C with an acute accent over it needs replacing with a C etc. The 2 Turkish characters which are now ?s (they looked right when this was previewed before posting) were an S with a cedilla under it and a G with a curved line above it which need...

I'm sure this has been asked many times before but I can't find any previous threads, so here goes... I have a spreadsheet which imports data from webpages into an Access database. Before writing the data it goes through and replaces all the accented characters with the non-accented version...

Cheers Geoff, I like to see where it is up to so have changed it to use both mentions of "Webpages" which is a bit of overkill but will hopefully also reduce the chance of it messing up.

p.s. It's Excel 2000

I am running a VBA function that repeatedly opens webpages and then extracts data from them. I have a seperate sheet setup for the webpages to load into but every so often they open on another random sheet writing over it's contents. The code I am using to open the pages is...

If you are trying to load items from a spreadsheet then try using eBay's Turbo Lister. You can import and export from csv files. They recently had a free listing day and I wanted to list loads of items which I had catalogued in Excel. I manually entered one of the items into Turbo Lister...