Thread: spreadsheet to autogenerate calendar

I'm wondering if there is a way to create a spreadsheet that has the possibilty of autogenerating a calendar. If not, I'm wondering if there is a way of simply copying spreadsheet data to a correlating excel calendar. This is extremely important to my business. My company does not use Outlook so that is not a possible solution at this point

Thank you in advance to anyone for their help!!!!!

Originally Posted by demers7847

I'm wondering if there is a way to create a spreadsheet that has the possibilty of autogenerating a calendar. If not, I'm wondering if there is a way of simply copying spreadsheet data to a correlating excel calendar. This is extremely important to my business. My company does not use Outlook so that is not a possible solution at this point

Thank you in advance to anyone for their help!!!!!

Depends precisely what you want to achieve with the calendar. There are numerous Excel calendar templates on line, for instance:

http://office.microsoft.com/en-us/te...ndar&av=TPL000

If however you want a pop up calendar from which you can select dates for populating cells on the worksheet, then there is a Calendar Object in the VBE (Visual Basic environment) which sits 'behind' the spreadsheet. You could have a simple macro attached to a button which could open this up for you to use.

HTH

I modified this code based on some from a user in another forum.

It will mess up if you have modified your regional settings for date formats

I really like this code, and use it personally to generate calendars for scheduling etc



Lee