topic VBScript: Get data from excel cell and load it into variable in QlikView https://community.qlik.com/t5/QlikView/VBScript-Get-data-from-excel-cell-and-load-it-into-variable/m-p/1461061#M793038 <HTML><HEAD></HEAD><BODY><P>I'm trying to get a value from a cell in Excel that I calculate with a formula and then load the said value into a variable, to be used further down into the macro. </P><P>I've tried with: set vAverage = XLDoc.Sheets(1).Range("B2").Value but I get an "Object required: 'XLDoc.Sheets(...).Range(...).Value' " error. Any help? </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z VBScript: Get data from excel cell and load it into variable https://community.qlik.com/t5/QlikView/VBScript-Get-data-from-excel-cell-and-load-it-into-variable/m-p/1461061#M793038 <HTML><HEAD></HEAD><BODY><P>I'm trying to get a value from a cell in Excel that I calculate with a formula and then load the said value into a variable, to be used further down into the macro. </P><P>I've tried with: set vAverage = XLDoc.Sheets(1).Range("B2").Value but I get an "Object required: 'XLDoc.Sheets(...).Range(...).Value' " error. Any help? </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/VBScript-Get-data-from-excel-cell-and-load-it-into-variable/m-p/1461061#M793038 Anonymous 2020-11-25T16:16:04Z Re: VBScript: Get data from excel cell and load it into variable https://community.qlik.com/t5/QlikView/VBScript-Get-data-from-excel-cell-and-load-it-into-variable/m-p/1461062#M793039 <HTML><HEAD></HEAD><BODY><P>The cell-content isn't an object else just a value therefore try it with:</P><P></P><P>vAverage = XLDoc.Sheets(1).Range("B2").Value</P><P></P><P>- Marcus</P></BODY></HTML> Tue, 09 Jan 2018 09:56:12 GMT https://community.qlik.com/t5/QlikView/VBScript-Get-data-from-excel-cell-and-load-it-into-variable/m-p/1461062#M793039 marcus_sommer 2018-01-09T09:56:12Z Re: VBScript: Get data from excel cell and load it into variable https://community.qlik.com/t5/QlikView/VBScript-Get-data-from-excel-cell-and-load-it-into-variable/m-p/1461063#M793040 <HTML><HEAD></HEAD><BODY><P>That's it! Thanks!</P></BODY></HTML> Tue, 09 Jan 2018 10:08:49 GMT https://community.qlik.com/t5/QlikView/VBScript-Get-data-from-excel-cell-and-load-it-into-variable/m-p/1461063#M793040 Anonymous 2018-01-09T10:08:49Z Re: VBscript&colon; Get data from excel cell and load it into variable https://community.qlik.com/t5/QlikView/VBScript-Get-data-from-excel-cell-and-load-it-into-variable/m-p/1524717#M793041 <P>Please help me!</P><P>I'm having the same problem.</P><P>But I do not not how to replace the "XLDOC"</P><P>What is "XLDOC" here? Is this the path where the Excel file located?</P> Fri, 28 Dec 2018 08:10:32 GMT https://community.qlik.com/t5/QlikView/VBScript-Get-data-from-excel-cell-and-load-it-into-variable/m-p/1524717#M793041 Anonymous 2018-12-28T08:10:32Z