I have recorded a data source query from an external file with the macr
recorder.
This query included a filter, the date and time:

......statestart={ts '2004-09-1
09:14:14'})......

Now I would like to replace this date/time referring to a date/tim
value of a cell within a worksheet to have a more efficient an
flexible quer

--
thomipilo
-----------------------------------------------------------------------
thomipilot's Profile: http://www.excelforum.com/member.php...fo&userid=1488
View this thread: http://www.excelforum.com/showthread.php?threadid=26512

".....statestart={ts '" & format(Range("A1"),"YYYY-MM-DD hh:mm:ss") &
"'})......"

--
Regards,
Tom Ogilvy


"thomipilot" wrote in message
...

I have recorded a data source query from an external file with the macro
recorder.
This query included a filter, the date and time:

.....statestart={ts '2004-09-15
09:14:14'})......

Now I would like to replace this date/time referring to a date/time
value of a cell within a worksheet to have a more efficient and
flexible query


--
thomipilot
------------------------------------------------------------------------
thomipilot's Profile:
http://www.excelforum.com/member.php...o&userid=14883
View this thread: http://www.excelforum.com/showthread...hreadid=265126