Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
As already suggested - try quoting the values.
With .document.Forms(0) .txtFromDt.Value = "05/02/2008" .txtToDt.Value = "05/02/2008" End With Tim "Vijay Kotian" wrote in message ... Forget the codes mentioned eariler ..... I am getting stuck at the following codes i.e. With .document.Forms(0) .txtFromDt.Value = 05/02/2008 .txtToDt.Value = 05/02/2008 End With I would like to pass date but getting error as "Object Variable or with block variable not set" ? The codes of web is as under OR can you rewrite the code so that I can pass date value through VBA ; |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Save data retreived from query without saving query | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Stop to modify the SQL query manually entered into query ! | Excel Programming |