The following code I wrote ( assuming you are using IE 7 with tab viewing). Some things you need to know, you go to the page above and have it in the foreground as I did not add any type of enumeration detection for correct windows.

You should be able to add the code to a VB excel macro so that you can run the code. You need to add a reference to Microsoft HTML object library. The code really has nothing to do with excel itself it's just an example of how to auto fill a website with your information.

For example.
HtmlDoc.getElementById("ProblemType").Value = "Computer"

This changes the first combo field on the website to "Computer", (ProblemType) is the name= of the option combo on the website which you can see by right clicking the website and choosing "View Source".

Add this line directly under the. It should return ( Dell - Support ) if it's not then the support site is night in the foreground
'// TODO: Proceed to fill out the form in here.
Debug.Print HtmlDoc.Title

At this stage, I haven't got a Dell Case to lodge, so I can't fully test it. This currently does not submit a case. I want to wait to see what the confirmation page looks like, so I can try to get the case reference number back to column W. After you submit one, can you please post a screenshot of the case reference screen, and I will try to have it automatically gather that. To get this right, we'd be best off testing with one case in the excel file at a time.

I take is that the error MsgBox is appearing before the page has even finished loading? This is problem....we need to make the script wait for the page to fully load.....and if it loads new windows, I think this becomes a problem....

OK Great. Hopefully one last thing I need from you then....
On screen number one that you posted, where you need to click Submit, if you hover your mouse over that Submit button, down the bottom of the browser window, you should see something like

javascript:XXXXXX();

You know, in the part of the browser that shows you the address a link goes to.....well, I need to know exactly what that says, case sensitive.

Hi Sharath, I didn't notice there's no taskbar on the second window. I already had the first one, it's sitting there waiting to be executed, currently commented out...
'objIE.document.frames.execScript "Returnvalid()", "JavaScript"

so, instead, we'll need to "View Source" on the second page, and search for the instance of "javascript:" that relates to the submit link, to get the function name that it calls.

If you can find that, that would be great if you could fine them (there may be more than one "javascript:" written in the code, so just post them all), otherwise, I'll probably have a case next week to lodge....

With the present code in the excel that you have attached you will be able to go to the 2nd page.... Only after you click submit on the 2nd page will you go to the submitting of the problem. So can you please go and see what happens.

Rob i get this
2.00806E+16
When double click i get the format right...
But the actual call no that was on the screen and the mail i received was this
20080630002857571
But when double click the cell i get this
20080630002857500

I tried with 2 call and both had the same issue.

the 2nd call no is this in excel
20080630003210400
but the mail and the final ie summary was this
20080630003210457

Rob i get this
2.00806E+16
When double click i get the format right...
But the actual call no that was on the screen and the mail i received was this
20080630002857571
But when double click the cell i get this
20080630002857500

I tried with 2 call and both had the same issue.

the 2nd call no is this in excel
20080630003210400
but the mail and the final ie summary was this
20080630003210457