I am using the scheduler to move data from one cell to another cell in a different row. I need to have the scheduler check for NULL or blank data in a cell to determine how some this is data is moved inside a spreadsheet.
How can I read the contents for a cell, specifically to identify NULL's??
Reading data in a cell in an Excel Spreadsheet
Moderators: JRL, Dorian (MJT support)
-
Peter Gozinya
- Newbie
- Posts: 1
- Joined: Wed Jan 28, 2004 9:11 pm
Hi,
How are you querying Excel - VBScript/AciveX or DDE? If using VBScript/ActiveX then you can compare to NIL in VBScript. NIL is VBScript's version of NULL in Excel.
In MacroScript compare to nothing, literally, or check it's length with Position, or pass to VBScript and compare with NIL.
if>a=,nothing,something
That would perform nothing if a was nothing.
How are you querying Excel - VBScript/AciveX or DDE? If using VBScript/ActiveX then you can compare to NIL in VBScript. NIL is VBScript's version of NULL in Excel.
In MacroScript compare to nothing, literally, or check it's length with Position, or pass to VBScript and compare with NIL.
if>a=,nothing,something
That would perform nothing if a was nothing.
MJT Net Support
[email protected]
[email protected]
