Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populating a calendar with VBA
I understand my original question was very broad and a bit complex but
in case anyone was interested in a solution then here you go! It works marvelously. I built an addin that takes a spreadsheet and configures the raw data for export to a csv file. This csv file is then used by an external app named "XL Calendar". This app is available at LJZSoft.Com. It's a very basic calendar app that creates the user's calendar in an excel file. The wonderful feature is that it will take a custom "holiday" file and import it that into your new calendar. By modifying my data into the format used for the "holiday" file I was able to create a caledar showing all of my customer due dates. I created a secondary macro built into my add-in to further format the calendar to allow for a lot of data to be packed into each day on the calendar. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert date from Gregorian Calendar to Hijri Calendar | Excel Discussion (Misc queries) | |||
find free sharware to include calendar pop or use calendar in cell | Excel Discussion (Misc queries) | |||
Populating a calendar from another worksheet | Excel Worksheet Functions | |||
Populating an excel calendar - eg. 10x tuesday/thursday from date x | Links and Linking in Excel | |||
Modify Yearly Calendar to Monthly Calendar Excel 2000? | Excel Programming |