how is the syntax to replace a date, recorded within a macro with a cell value ?

  • Thread starter Thread starter thomipilot
  • Start date Start date
T

thomipilot

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
 
".....statestart>={ts '" & format(Range("A1"),"YYYY-MM-DD hh:mm:ss") &
"'})......"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change Pivot Table Filter Based on Cell Value 0
Use cell value to adjust date range 1
How to copy row data from Sheet2 to Sheet1 based on Conditional Date 2
changing a recorded macro - date problem.... 5
Replace cell formula with revised text as noted within a cell valu 3
Filter Table based on Cell Value 1
pasting of variable cell value into macro 2
5 months prior to date macro help please 13

Back
Top