Hi,
I am new to this forum and to VBA in general.
I am getting the above error when I run my VBA code in full. It doesn't happen when I use the debug and step into.
When running the code, the debug hightlights this line in the code., Range("C" & rw).Value = doc.getElementById("routeDistanceValue").innerHTML
I would be grateful if someone could point me in the right direction or suggest a way to get around the error.
Many thanks
Alan
Hello wkddj51,
You're mostly likely automating Internet Explorer with VBA. The problem is caused by a lack of synchronization between the IE application and the VBA environment.
There are ways to deal with this issue. Usually, I will not use Internet Explorer but sometimes it is unavoidable. To help with this problem, we need to see what code you have. If can post a copy of your workbook then that would be best.
Please redact any sensitive or confidential information before you post the workbook.
How To Post Your Workbook
- At the bottom right of the Reply window, Click the button Go Advanced
- At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
- Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
- Click the Select Files button at the bottom middle of the dialog.
- In the new window Find the file you want to upload, select it, and Click Open.
- You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
- Wait until the file has completely uploaded before you exit the File Manager dialog.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Leith,
Thank you for your reply and I attached a sample file with code. The data is a good representation of the data in the larger file(about 2,500)
I am still getting the above error so any assistance or point the right direction will be very welcome.
Also, I am not sure if I have handled correctly the If statement for checking the From Postcode column for existence of data.
Again, thanks in advance. I appreciate all help.
Kind regards
Alan
Thread closed,As per forum rules(Op posted in Commercial sub forum.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks