kalu
01-05-2010, 07:38 PM
Greetings to everyone out here in this fourm.
can any one please guide me how can i get value from an unopened excel sheet so that i can check the value and popup message.
i'm trying to do by using personal.xls but i have "myvalue.xls" from which sheet1 i have to check the value. Professionally i'm not a programmer so i have no solid knowledge of variables loops etc.
here is my logic which i need to put in personal.xls
IF
c:\data\myvalue.xls\sheet1(row3)>today
then
msgbox "time has expired
else
msgbox "everyone is okay"
end if
my main problem over here is how to code checking the value of an unopened xls file
thanks in advance
kalu
can any one please guide me how can i get value from an unopened excel sheet so that i can check the value and popup message.
i'm trying to do by using personal.xls but i have "myvalue.xls" from which sheet1 i have to check the value. Professionally i'm not a programmer so i have no solid knowledge of variables loops etc.
here is my logic which i need to put in personal.xls
IF
c:\data\myvalue.xls\sheet1(row3)>today
then
msgbox "time has expired
else
msgbox "everyone is okay"
end if
my main problem over here is how to code checking the value of an unopened xls file
thanks in advance
kalu