software

I am trying to create a user friendly document for my colleagues.

I have created an excel query that gets data from our back office system.
This query gets information for all 12 months of the year. From all this
data, a report needs to be created for 1 month of the data depending on which
month the user needs to create a report for. I would like the report to be
created automatically (through macros etc...) once the user has inputed which
month/year he requires.
I am not sure how to go about this. 1 alternative I was considering would be
to have a message box pop onto the screen and then from this box the user
could pick his month/yr and then I could grab the values in order to create
the required report. Or, another alternative would be to create a form that
the user could enter the info into and then I could grab the values in order
to create the required report.
I am having difficulty finding information on both of these ideas. Can
someone help me?
Thanks!

The easiest is to use an inputbox

res = InputBox(quot;Enter a month, ex: quot;Janquot;)

If you wanted to trigger this from a Refresh, you would need to instantiate
events for the query.

support.microsoft.com/kb/213187/en-us
XL2000: How to Use the Query BeforeRefresh and AfterRefresh Events

--
Regards,
Tom Ogilvy
quot;85225quot; wrote:

gt; I am trying to create a user friendly document for my colleagues.
gt;
gt; I have created an excel query that gets data from our back office system.
gt; This query gets information for all 12 months of the year. From all this
gt; data, a report needs to be created for 1 month of the data depending on which
gt; month the user needs to create a report for. I would like the report to be
gt; created automatically (through macros etc...) once the user has inputed which
gt; month/year he requires.
gt; I am not sure how to go about this. 1 alternative I was considering would be
gt; to have a message box pop onto the screen and then from this box the user
gt; could pick his month/yr and then I could grab the values in order to create
gt; the required report. Or, another alternative would be to create a form that
gt; the user could enter the info into and then I could grab the values in order
gt; to create the required report.
gt; I am having difficulty finding information on both of these ideas. Can
gt; someone help me?
gt; Thanks!

Is there another function similar to the inputbox but where there is a
dropdown list box from which the user can pick a month, thus eliminating
spelling mistakes?

quot;Tom Ogilvyquot; wrote:

gt; The easiest is to use an inputbox
gt;
gt; res = InputBox(quot;Enter a month, ex: quot;Janquot;)
gt;
gt; If you wanted to trigger this from a Refresh, you would need to instantiate
gt; events for the query.
gt;
gt; support.microsoft.com/kb/213187/en-us
gt; XL2000: How to Use the Query BeforeRefresh and AfterRefresh Events
gt;
gt; --
gt; Regards,
gt; Tom Ogilvy
gt;
gt;
gt;
gt; quot;85225quot; wrote:
gt;
gt; gt; I am trying to create a user friendly document for my colleagues.
gt; gt;
gt; gt; I have created an excel query that gets data from our back office system.
gt; gt; This query gets information for all 12 months of the year. From all this
gt; gt; data, a report needs to be created for 1 month of the data depending on which
gt; gt; month the user needs to create a report for. I would like the report to be
gt; gt; created automatically (through macros etc...) once the user has inputed which
gt; gt; month/year he requires.
gt; gt; I am not sure how to go about this. 1 alternative I was considering would be
gt; gt; to have a message box pop onto the screen and then from this box the user
gt; gt; could pick his month/yr and then I could grab the values in order to create
gt; gt; the required report. Or, another alternative would be to create a form that
gt; gt; the user could enter the info into and then I could grab the values in order
gt; gt; to create the required report.
gt; gt; I am having difficulty finding information on both of these ideas. Can
gt; gt; someone help me?
gt; gt; Thanks!

No. No built in popup menu. In a cell you could use Data =gt;Validation from
a pop up menu. See Debra Dalgleish's site for examples.

www.contextures.com/tiptech.html

--
Regards,
Tom Ogilvyquot;85225quot; wrote:

gt; Is there another function similar to the inputbox but where there is a
gt; dropdown list box from which the user can pick a month, thus eliminating
gt; spelling mistakes?
gt;
gt; quot;Tom Ogilvyquot; wrote:
gt;
gt; gt; The easiest is to use an inputbox
gt; gt;
gt; gt; res = InputBox(quot;Enter a month, ex: quot;Janquot;)
gt; gt;
gt; gt; If you wanted to trigger this from a Refresh, you would need to instantiate
gt; gt; events for the query.
gt; gt;
gt; gt; support.microsoft.com/kb/213187/en-us
gt; gt; XL2000: How to Use the Query BeforeRefresh and AfterRefresh Events
gt; gt;
gt; gt; --
gt; gt; Regards,
gt; gt; Tom Ogilvy
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;85225quot; wrote:
gt; gt;
gt; gt; gt; I am trying to create a user friendly document for my colleagues.
gt; gt; gt;
gt; gt; gt; I have created an excel query that gets data from our back office system.
gt; gt; gt; This query gets information for all 12 months of the year. From all this
gt; gt; gt; data, a report needs to be created for 1 month of the data depending on which
gt; gt; gt; month the user needs to create a report for. I would like the report to be
gt; gt; gt; created automatically (through macros etc...) once the user has inputed which
gt; gt; gt; month/year he requires.
gt; gt; gt; I am not sure how to go about this. 1 alternative I was considering would be
gt; gt; gt; to have a message box pop onto the screen and then from this box the user
gt; gt; gt; could pick his month/yr and then I could grab the values in order to create
gt; gt; gt; the required report. Or, another alternative would be to create a form that
gt; gt; gt; the user could enter the info into and then I could grab the values in order
gt; gt; gt; to create the required report.
gt; gt; gt; I am having difficulty finding information on both of these ideas. Can
gt; gt; gt; someone help me?
gt; gt; gt; Thanks!

Thank you for your help.

quot;Tom Ogilvyquot; wrote:

gt; No. No built in popup menu. In a cell you could use Data =gt;Validation from
gt; a pop up menu. See Debra Dalgleish's site for examples.
gt;
gt; www.contextures.com/tiptech.html
gt;
gt; --
gt; Regards,
gt; Tom Ogilvy
gt;
gt;
gt; quot;85225quot; wrote:
gt;
gt; gt; Is there another function similar to the inputbox but where there is a
gt; gt; dropdown list box from which the user can pick a month, thus eliminating
gt; gt; spelling mistakes?
gt; gt;
gt; gt; quot;Tom Ogilvyquot; wrote:
gt; gt;
gt; gt; gt; The easiest is to use an inputbox
gt; gt; gt;
gt; gt; gt; res = InputBox(quot;Enter a month, ex: quot;Janquot;)
gt; gt; gt;
gt; gt; gt; If you wanted to trigger this from a Refresh, you would need to instantiate
gt; gt; gt; events for the query.
gt; gt; gt;
gt; gt; gt; support.microsoft.com/kb/213187/en-us
gt; gt; gt; XL2000: How to Use the Query BeforeRefresh and AfterRefresh Events
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Regards,
gt; gt; gt; Tom Ogilvy
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;85225quot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I am trying to create a user friendly document for my colleagues.
gt; gt; gt; gt;
gt; gt; gt; gt; I have created an excel query that gets data from our back office system.
gt; gt; gt; gt; This query gets information for all 12 months of the year. From all this
gt; gt; gt; gt; data, a report needs to be created for 1 month of the data depending on which
gt; gt; gt; gt; month the user needs to create a report for. I would like the report to be
gt; gt; gt; gt; created automatically (through macros etc...) once the user has inputed which
gt; gt; gt; gt; month/year he requires.
gt; gt; gt; gt; I am not sure how to go about this. 1 alternative I was considering would be
gt; gt; gt; gt; to have a message box pop onto the screen and then from this box the user
gt; gt; gt; gt; could pick his month/yr and then I could grab the values in order to create
gt; gt; gt; gt; the required report. Or, another alternative would be to create a form that
gt; gt; gt; gt; the user could enter the info into and then I could grab the values in order
gt; gt; gt; gt; to create the required report.
gt; gt; gt; gt; I am having difficulty finding information on both of these ideas. Can
gt; gt; gt; gt; someone help me?
gt; gt; gt; gt; Thanks!