control the positioning and the size of the window

[EDUCATED MONKEY]

My set up office 2007 win xp pro ie 8
I am using the code below to retrieve web pages etc it works fine, however it display in differ areas of the screen, so I was wondering if there is a way to control the positioning and the size of the window?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>

  Set EXP = CreateObject("InternetExplorer.application")
                            EXP.Visible = True
                               EXP.Navigate (aurl)
                    Do While EXP.Busy
        Application.Wait DateAdd("s", 1, Now)
    Loop
             ' Application.Wait (Now + TimeSerial(0, 0, 5))
                                 SendKeys "^a"
                               SendKeys "^c"
        Application.Wait (Now + TimeSerial(0, 0, 3))
                      Worksheets("Recieved Data").Select
                      Worksheets("Recieved Data").Range("A1").Select
ActiveSheet.PasteSpecial Format:="text", LINK:=False, DisplayAsIcon:= _
   False
 Application.ScreenUpdating = True

 

[tlowry]

If you want to change the size and position of the IE window:

With oIE ' oIE instead for Exp
        .Left = 100
        .Top = 100
        .Width = 200
        .Height = 200
End With

See:

http://www.mrexcel.com/forum/showthread.php?t=485219

for more information on this

For the Excel window:

With Application
        .WindowState = xlNormal
        .Left = 200
        .Width = 300
        .Height = 200
        .Top = 100
End With

 

[EDUCATED MONKEY]

Thank you reading the code it seems reasonable in the unlikly event i have any problems i will get back to you
and thanks for taking the time to post your reply
regards pete