display calendar for a given month or date range in a row without weekends

I'm not really understanding what you're trying to accomplish. If you could attach an example of what you want this calendar to look like, that might help.

Thanks for your response natefarm.
What I'm trying to do is something like in the attached worksheet.
I'm very comfortable with the SqL call part.
I am quite new to vba programming :-(

More questions:
Please clarify what you mean by "given start and end date".
If that includes more than one month, do you want a full month's calendar created for each?
Would each calendar be on a separate sheet or on the same one?
Do you want just the two heading rows, or a full grid. How would the number of rows be determined?
You have a lot of formatting there (borders, font color, background color). Is the code to provide all that?

Hey thanks for your quick responses

I plan to use a VBA Form as means of input for the the query.

I hope calculate the number of rows by subtracting the start date from end date. I plan to make it a 30 day calendar(maybe prompt the user to give a 30-Day period).
I'd like to have the two heading rows, if possible.
I'd like to keep it around a month per query to reduce complexity and the formatting are not quite necessary.

You say you want the days in rows, but in your attachment you have the days in columns and some other values in the rows. Also, you say a 30-day period, but the attachment has the 31 days of January. I guess I'm still confused.

Oh sorry for the confusion! the days should be in columns(I need to place the resources needed on a date in their appropriate columns) and yes it should be a 31-day period :-)

Thanks for your patience natefarm

Sorry this took so long. Got busy, then lost your code and had to start over. Anyway, this is a start. Adjust as needed, and if you need more help, let me know.

Please Login or Register  to view this content.

Thanks a lot natefarm! That was a life saver! I have written too many complex code that are half as efficient!

Thanks once again for your time

My pleasure!