software

For importing external data into Excel, I use Microsoft Query. If I use
parameter gt;=#7/28/2005# in the query itself, it works, but it doesn't work
if, in Excel, I want to quot;Get the value from the following cellquot; or quot;Use the
following valuequot;.

Ronco,

What happens when you use Get value from the following cell?

What value is the cell you are using? What is the format of the cell? Date?

I have no problems using a date field in a parameter MS Query. Although I
have to use a specific format because the data I am querying uses a
proprietary date format.

quot;Roncoquot; wrote:

gt; For importing external data into Excel, I use Microsoft Query. If I use
gt; parameter gt;=#7/28/2005# in the query itself, it works, but it doesn't work
gt; if, in Excel, I want to quot;Get the value from the following cellquot; or quot;Use the
gt; following valuequot;.

Dominic, when I use the Get value from the following cell, an error msg box
quot;Bad parameter type. Microsoft Office Excel is expecting a different kind of
value than what was provided.quot; comes up.

The cell format is Date 3/14/01. When I use a cell value of 7/28/05, it
works, but the value gt;=7/28/05 doesn't. The quot;gt;=quot; part is what Excel doesn't
like. I've tried every variation I can think of: gt;=#7/28/05#, gt;='7/28/05',
etc., but I still can't get it to work. I have to edit the query each time I
want to change the date.

quot;Dominicquot; wrote:

gt; Ronco,
gt;
gt; What happens when you use Get value from the following cell?
gt;
gt; What value is the cell you are using? What is the format of the cell? Date?
gt;
gt; I have no problems using a date field in a parameter MS Query. Although I
gt; have to use a specific format because the data I am querying uses a
gt; proprietary date format.
gt;
gt; quot;Roncoquot; wrote:
gt;
gt; gt; For importing external data into Excel, I use Microsoft Query. If I use
gt; gt; parameter gt;=#7/28/2005# in the query itself, it works, but it doesn't work
gt; gt; if, in Excel, I want to quot;Get the value from the following cellquot; or quot;Use the
gt; gt; following valuequot;.

Ronco, you should leave 7/28/05 in the cell.

The gt;= goes in the Query Design grid in MS Query.

For example:

gt;=[Parameter Name]

instead of just

[Parameter Name]Does that help?quot;Roncoquot; wrote:

gt; Dominic, when I use the Get value from the following cell, an error msg box
gt; quot;Bad parameter type. Microsoft Office Excel is expecting a different kind of
gt; value than what was provided.quot; comes up.
gt;
gt; The cell format is Date 3/14/01. When I use a cell value of 7/28/05, it
gt; works, but the value gt;=7/28/05 doesn't. The quot;gt;=quot; part is what Excel doesn't
gt; like. I've tried every variation I can think of: gt;=#7/28/05#, gt;='7/28/05',
gt; etc., but I still can't get it to work. I have to edit the query each time I
gt; want to change the date.
gt;
gt; quot;Dominicquot; wrote:
gt;
gt; gt; Ronco,
gt; gt;
gt; gt; What happens when you use Get value from the following cell?
gt; gt;
gt; gt; What value is the cell you are using? What is the format of the cell? Date?
gt; gt;
gt; gt; I have no problems using a date field in a parameter MS Query. Although I
gt; gt; have to use a specific format because the data I am querying uses a
gt; gt; proprietary date format.
gt; gt;
gt; gt; quot;Roncoquot; wrote:
gt; gt;
gt; gt; gt; For importing external data into Excel, I use Microsoft Query. If I use
gt; gt; gt; parameter gt;=#7/28/2005# in the query itself, it works, but it doesn't work
gt; gt; gt; if, in Excel, I want to quot;Get the value from the following cellquot; or quot;Use the
gt; gt; gt; following valuequot;.

Thanks, Dominic, it worked. That was so simple I'm embarrassed. It's the
input I needed for other queries as well. Thanks again.

quot;Dominicquot; wrote:

gt; Ronco, you should leave 7/28/05 in the cell.
gt;
gt; The gt;= goes in the Query Design grid in MS Query.
gt;
gt; For example:
gt;
gt; gt;=[Parameter Name]
gt;
gt; instead of just
gt;
gt; [Parameter Name]
gt;
gt;
gt; Does that help?
gt;
gt;
gt; quot;Roncoquot; wrote:
gt;
gt; gt; Dominic, when I use the Get value from the following cell, an error msg box
gt; gt; quot;Bad parameter type. Microsoft Office Excel is expecting a different kind of
gt; gt; value than what was provided.quot; comes up.
gt; gt;
gt; gt; The cell format is Date 3/14/01. When I use a cell value of 7/28/05, it
gt; gt; works, but the value gt;=7/28/05 doesn't. The quot;gt;=quot; part is what Excel doesn't
gt; gt; like. I've tried every variation I can think of: gt;=#7/28/05#, gt;='7/28/05',
gt; gt; etc., but I still can't get it to work. I have to edit the query each time I
gt; gt; want to change the date.
gt; gt;
gt; gt; quot;Dominicquot; wrote:
gt; gt;
gt; gt; gt; Ronco,
gt; gt; gt;
gt; gt; gt; What happens when you use Get value from the following cell?
gt; gt; gt;
gt; gt; gt; What value is the cell you are using? What is the format of the cell? Date?
gt; gt; gt;
gt; gt; gt; I have no problems using a date field in a parameter MS Query. Although I
gt; gt; gt; have to use a specific format because the data I am querying uses a
gt; gt; gt; proprietary date format.
gt; gt; gt;
gt; gt; gt; quot;Roncoquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; For importing external data into Excel, I use Microsoft Query. If I use
gt; gt; gt; gt; parameter gt;=#7/28/2005# in the query itself, it works, but it doesn't work
gt; gt; gt; gt; if, in Excel, I want to quot;Get the value from the following cellquot; or quot;Use the
gt; gt; gt; gt; following valuequot;.

You're welcome. Glad I could help.
quot;Roncoquot; wrote:

gt; Thanks, Dominic, it worked. That was so simple I'm embarrassed. It's the
gt; input I needed for other queries as well. Thanks again.
gt;
gt; quot;Dominicquot; wrote:
gt;
gt; gt; Ronco, you should leave 7/28/05 in the cell.
gt; gt;
gt; gt; The gt;= goes in the Query Design grid in MS Query.
gt; gt;
gt; gt; For example:
gt; gt;
gt; gt; gt;=[Parameter Name]
gt; gt;
gt; gt; instead of just
gt; gt;
gt; gt; [Parameter Name]
gt; gt;
gt; gt;
gt; gt; Does that help?
gt; gt;
gt; gt;
gt; gt; quot;Roncoquot; wrote:
gt; gt;
gt; gt; gt; Dominic, when I use the Get value from the following cell, an error msg box
gt; gt; gt; quot;Bad parameter type. Microsoft Office Excel is expecting a different kind of
gt; gt; gt; value than what was provided.quot; comes up.
gt; gt; gt;
gt; gt; gt; The cell format is Date 3/14/01. When I use a cell value of 7/28/05, it
gt; gt; gt; works, but the value gt;=7/28/05 doesn't. The quot;gt;=quot; part is what Excel doesn't
gt; gt; gt; like. I've tried every variation I can think of: gt;=#7/28/05#, gt;='7/28/05',
gt; gt; gt; etc., but I still can't get it to work. I have to edit the query each time I
gt; gt; gt; want to change the date.
gt; gt; gt;
gt; gt; gt; quot;Dominicquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Ronco,
gt; gt; gt; gt;
gt; gt; gt; gt; What happens when you use Get value from the following cell?
gt; gt; gt; gt;
gt; gt; gt; gt; What value is the cell you are using? What is the format of the cell? Date?
gt; gt; gt; gt;
gt; gt; gt; gt; I have no problems using a date field in a parameter MS Query. Although I
gt; gt; gt; gt; have to use a specific format because the data I am querying uses a
gt; gt; gt; gt; proprietary date format.
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Roncoquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; For importing external data into Excel, I use Microsoft Query. If I use
gt; gt; gt; gt; gt; parameter gt;=#7/28/2005# in the query itself, it works, but it doesn't work
gt; gt; gt; gt; gt; if, in Excel, I want to quot;Get the value from the following cellquot; or quot;Use the
gt; gt; gt; gt; gt; following valuequot;.