Macro to Prompt User for Date Range when Opening Spreadsheet
I am sure this has already been answered but when I try to search with that exact wording I keep getting an error message.
So here goes. I have a table linked through Excel to an ODBC database. I want to prompt the user when opening this spreasheet to input a start date and an end date to retrieve only the records within that date range.
I do not do alot with Macros so please be patient with me. Thanks.
Michelle
Maybe something like this:
Please Login or Register to view this content.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
Thanks Dave! Now how do I get it to only pull the records with an INVDTE within that range?
Michelle
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks