Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ask for date
I receive a file (bi-weekly) which is then sorted by Macro into various
worksheets and sent to Departments for their research and response. How could I get a message to appear which would ask me for the date the worksheets will be sent to the departments and populate it into the database during the sort process? TIA Carole O |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ask for date
Assuming that you would like this to be done as part of the process run by
your "sorting" macro........that macro itself would have to be modified. Whoever wrote the original macro should be able to incorporate this new function. Vaya con Dios, Chuck, CABGx3 "Carole O" wrote: I receive a file (bi-weekly) which is then sorted by Macro into various worksheets and sent to Departments for their research and response. How could I get a message to appear which would ask me for the date the worksheets will be sent to the departments and populate it into the database during the sort process? TIA Carole O |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ask for date
I recorded the 'sorting' macro. I know there is a way to do this, I just
either have forgotten or don't know how. After the macro is started, it should pop up a question "What is the send date?" and give the person running the macro an opportunity to respond. The macro will then write that date to the 'send date' column in all the sorted files. Hope this clarifies what I am looking for. Carole O "CLR" wrote: Assuming that you would like this to be done as part of the process run by your "sorting" macro........that macro itself would have to be modified. Whoever wrote the original macro should be able to incorporate this new function. Vaya con Dios, Chuck, CABGx3 "Carole O" wrote: I receive a file (bi-weekly) which is then sorted by Macro into various worksheets and sent to Departments for their research and response. How could I get a message to appear which would ask me for the date the worksheets will be sent to the departments and populate it into the database during the sort process? TIA Carole O |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ask for date
You want InputBox, as in:
SendDate = InputBox("What is the send date?, , <default if wanted) -- Regards, Fred "Carole O" wrote in message ... I recorded the 'sorting' macro. I know there is a way to do this, I just either have forgotten or don't know how. After the macro is started, it should pop up a question "What is the send date?" and give the person running the macro an opportunity to respond. The macro will then write that date to the 'send date' column in all the sorted files. Hope this clarifies what I am looking for. Carole O "CLR" wrote: Assuming that you would like this to be done as part of the process run by your "sorting" macro........that macro itself would have to be modified. Whoever wrote the original macro should be able to incorporate this new function. Vaya con Dios, Chuck, CABGx3 "Carole O" wrote: I receive a file (bi-weekly) which is then sorted by Macro into various worksheets and sent to Departments for their research and response. How could I get a message to appear which would ask me for the date the worksheets will be sent to the departments and populate it into the database during the sort process? TIA Carole O |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to get the random date between the start date and the end date? | Excel Worksheet Functions | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel |