| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how is the syntax to replace a date, recorded within a macro with a cell value ?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
| How to FIX Recorded Macro | Excel Discussion (Misc queries) | |||
| Recorded Macro | New Users to Excel | |||
| Recorded macro has hard cell contents. | Excel Discussion (Misc queries) | |||
| RECORDED MACRO PASTE'S DATE DIFFERENTLY TO MANUAL PASTE | Excel Worksheet Functions | |||
Threaded Mode
