C Chip Pearson Dec 3, 2003 #2 Konrad, Can you be a bit more specific in your question? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Konrad, Can you be a bit more specific in your question? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
K konrad Dec 3, 2003 #3 something like var ExcelSheet; ExcelSheet = new _ ActiveXObject "Excel.Sheet","C:\\test.xls"); LABEL1.innerText = ExcelSheet.Sheets(1).cells(1,1).value ExcelSheet.Application.Quit ExcelSheet = "" Questions I just started using vbs formelly I used to use vba I dont know where I have to put declaration of var. this is tthe poin I'm stock. the rest code might work on click of object or document load (but I can do this.) Right now declaration in for egz. click
something like var ExcelSheet; ExcelSheet = new _ ActiveXObject "Excel.Sheet","C:\\test.xls"); LABEL1.innerText = ExcelSheet.Sheets(1).cells(1,1).value ExcelSheet.Application.Quit ExcelSheet = "" Questions I just started using vbs formelly I used to use vba I dont know where I have to put declaration of var. this is tthe poin I'm stock. the rest code might work on click of object or document load (but I can do this.) Right now declaration in for egz. click
T Tom Ogilvy Dec 3, 2003 #4 vbscript (vbs) doesn't support variable types. All variables are variant I believe.