BigJimSlade
Registered User.
- Local time
- Today, 19:36
- Joined
- Oct 11, 2000
- Messages
- 173
Hi, Big Jim here:
************
(some code ommitted)
Dim sht As Excel.Worksheet
Dim wkb As Excel.Workbook
PreSale(i).RFPLogin = sht.Cells(1, 1)
************
In cell (1,1), there is a null value. However, when I run the above line, Presale(i).RFPLogin becomes = 0 as opposed to null. When I look at the value of sht.Cells(1,1) in break mode, the value is also 0 as opposed to null.
I have gone back into the spreadsheet and replaced the null with other things, such as text, and the text imports fine, but I need the null value. What should I do?
Thanks in advance...
Big Jim
************
(some code ommitted)
Dim sht As Excel.Worksheet
Dim wkb As Excel.Workbook
PreSale(i).RFPLogin = sht.Cells(1, 1)
************
In cell (1,1), there is a null value. However, when I run the above line, Presale(i).RFPLogin becomes = 0 as opposed to null. When I look at the value of sht.Cells(1,1) in break mode, the value is also 0 as opposed to null.
I have gone back into the spreadsheet and replaced the null with other things, such as text, and the text imports fine, but I need the null value. What should I do?
Thanks in advance...
Big Jim