Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to
VBScript - how to create script reading from excel ?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to
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" wrote in message ... VBScript - how to create script reading from excel ? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to
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 -----Original Message----- 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" wrote in message ... VBScript - how to create script reading from excel ? . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to
vbscript (vbs) doesn't support variable types. All variables are variant I
believe. -- Regards, Tom Ogilvy "konrad" wrote in message ... 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 -----Original Message----- 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" wrote in message ... VBScript - how to create script reading from excel ? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|