• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Calendar for 2013 - 2020

G

ganzzu

New Member
Hi,


I have received this Excel calendar template file: http://db.tt/eUVa1G60


The requirement would be to modify it in order to add events in the database for at least year 2013 (but it would be perfect to be able to also add for 2014, 2015 and so on) and the calendar (the Overview and each Month sheet) should be able to update itself with the new added events. Don't mind the 'Actions' and 'Other actions' forms - they may also be deleted from there. The Events form is the important one.


The thing is I haven't worked so much with macros and VBA and it is hard for me to solve it fast. Can you please give me a helping hand?


Thanks a lot!
 
Hi ,


I am sorry if I sound discouraging , but this is not something that many will do voluntarily , and for free.


One of the modules contains code of more than 1000 lines , not all of it written to be readable.


The design itself does not seem to be very professionally done , and completing your requirement is going to be an arduous and time-consuming job.


Can you say what your timeframe for completion is ?


Narayan
 
Hi,


Yes, I saw that module 1 code but I thought there may be some small modifications to that code in order to fulfil the requirements for the next year(s). This has to be completed for next week.


Regards
 
I managed to clean up and repair a bit the code, deleted unnecessary things and I customized 3 files for 3 different years (gave up trying to modify the code in order to keep same file for multiple years).


Now I have to find a way to fulfil another requirement - If some events are copy/pasted in the database sheet (same header, structure and cell format) how can I do to add them and be displayed in the calendar sheets (actually in the Overview sheet)? Can you give me some VBA hints on that?


Thanks!
 
You must log in or register to reply here.
Back
Top