Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2003 Macro not working in 2007
Can someone please help. I have macro for IE automation in 2003 but I do not
know VBA. Here is the code that works in 2003 but will not run in 2007. Does anyone know what the new code would be for Excel 2007. This is the VBA code Dim objIE As Object Set objIE = CreateObject("InternetExplorer.Application") With objIE .Navigate "http://mywebsite.com" Do While .Busy: DoEvents: Loop Do While .ReadyState < 4: DoEvents: Loop .Visible = True This is where Excel 2007 gets stuck. Do While .ReadyState < 4: DoEvents: Loop Then it gets stuck here. ..Document.getElementById("Description").Value = ActiveCell.Value Any help with translating this from 2003 to 2007 would be greatly appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
2003 Macro not working in 2007
I suspect you're missing a reference to Microsoft Internet Controls. Look
under Tools - References in the VBE and verity. -- HTH, Barb Reinhardt "kintaro" wrote: Can someone please help. I have macro for IE automation in 2003 but I do not know VBA. Here is the code that works in 2003 but will not run in 2007. Does anyone know what the new code would be for Excel 2007. This is the VBA code Dim objIE As Object Set objIE = CreateObject("InternetExplorer.Application") With objIE .Navigate "http://mywebsite.com" Do While .Busy: DoEvents: Loop Do While .ReadyState < 4: DoEvents: Loop .Visible = True This is where Excel 2007 gets stuck. Do While .ReadyState < 4: DoEvents: Loop Then it gets stuck here. .Document.getElementById("Description").Value = ActiveCell.Value Any help with translating this from 2003 to 2007 would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charts from 2003 not working in 2007 | Excel Discussion (Misc queries) | |||
Formual not working when 2003 WKB saved as 2007 Macro Enabled WKB | Excel Worksheet Functions | |||
Simple Excel 2003 macro not working in Excel 2007 | Excel Programming | |||
Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) | |||
Formulas in 2007 not working in 2003 | Excel Worksheet Functions |