On Mon, Nov 17, 2008 at 9:44 AM, Garrett Fitzgerald <[EMAIL PROTECTED]> wrote: > I have a Pivot Table worksheet in Excel 2007 that's running off a SQL > command. The dates in this statement are hardcoded at the moment: I'd > like to link them into a couple of cells in the sheet, but Excel is > being more unhelpful than usual. > > There's a greyed-out Parameters button at the bottom of the Connection > Properties: Definition tab, but no particular mention of how to get it > to actually work. I tried putting ?DateFrom and ?DateTo into the SQL: > it correctly recognized those as missing parameters (and gave me no > option to supply them), so I tried ?=B1 and ?=B2 instead: no dice > either. > > Help me save what little hair I have left, please. :-) ---------------------------
For the M$ fans there is Live Meeting where all you need is the website for the hosting and the tech line multi line phone set up that everyone can cal into and use. Have used this many times to present to people in NYC & Mesa AZ at the same time. -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
