how to create custom control in spreadsheet..

and be able to view in a page and use the macro code..

i was able to write create the object using iframe tag and use the macro of xls file at the same time but i could retrieve the rows and columns .. is there another way.. your commets is needed thnks .

 I am a little confused, though I must admit that I do not use much excel in conjunction with web programming.

Can you clarify what you have accomplished so far? what needs to be done?

 i have these program that was written in excel file(xls) worksheet/workbook.. these xls is to be embeded in the page for the user to interacts with the file generates its own macro returns that was written in there sell column/row..

ive embeded the xls file with the code ..

<IFRAME id="iframeexcel" title="excel" src="tempExcel.xls" width="100%" height="100%" runat="server">
    </IFRAME>

what i still need to do is to get the cell/row  value of the xls file that was embeded can these be done..

and when the page is initially loaded a open dialog box open and ask to open ,save or cancel. the file i dont need the dialog box how can i remove them.

 to access an excel cell value using vb. net (per this web page: http://www.xtremevbtalk.com/archive/index.php/t-225141.html)

Dim oApp As New Excel.Application
Dim oWBa As Excel.Workbook = oApp.Workbooks.Open("c:\Test.XLS")
Dim oWS As Excel.Worksheet = DirectCast(oWBa.Worksheets(1),
Excel.Worksheet)
oApp.Visible = False

MsgBox(oWS.Range("D6").Text)

....

For the dialog, I think it must because of the macro, you should be just go into the macro and disable that dialog.

Let me know if this helps