none
Outlook look-a-like calendar with meetings in excel macro and shapes! RRS feed

  • Question

  • Hello Everybody,

    I am tiring to create a meeting schedule where the following information will be asked:

    Name of the meeting, running from to (HH:mm as time) date is not required because all the meetings will be weekly recurring, place of the meetings (e.g.: office, webex, room123) , category (this will create the color for the shape) and thats it. 

    When I filled out the so called "database" I would like to add 1 button which will run a macro to create SHAPES in excel with the all the meetings and ordering them into a calendar look a like.

    I tryed to search for a start in many forums but nobody actually had this before (or my search was not deep enough). What i find mostly is that people extract the "database" to outlook where they will form the calendar look. 

    My problem is that i have plenty of meetings and sometimes i will have overlap, where I would like put the shapes (normal rectengulars) next to each other or overlapped.

    Does anybody did something like this before? Is it possible at all?

    For timing perspective i use excel as a base calendar 1 cell = 30 mins. and I do not have meetings in between. (e.g.: 715-945 or 823-1047) I just have 800-900 or 1030-1100. So the size of the shape should fit into the excel cell/row.

    Please help me with a start or something. 

    Thank you very much in advance!

    Monday, March 9, 2015 1:39 PM

Answers

  • Hi hlpbob007,

    >> My problem is that i have plenty of meetings and sometimes i will have overlap, where I would like put the shapes (normal rectengulars) next to each other or overlapped

    Do you mean that you want to draw shapes in some cells? If so, I would recommend you do as below to achieve your requirement.

    #get the coordinate of the cells, and then get the coordinate of the shapes you want to add, for this, you could use the top, left of the range

    # Range Properties (Excel)
    https://msdn.microsoft.com/EN-US/library/office/dn301006.aspx
    # add a shape with the method Shapes.AddShape, for more information about Shapes.AddShape, you could turn to the link below

    # Shapes.AddShape
    https://msdn.microsoft.com/en-us/library/office/ff821384.aspx

    If I misunderstood you, please feel free to let me know.

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Wednesday, March 11, 2015 9:30 AM

All replies

  • Hi,

    This is the forum to discuss questions and feedback for Microsoft Excel, I'll move your question to the MSDN forum for Excel

    http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

    George Zhao
    TechNet Community Support


    It's recommended to download and install Configuration Analyzer Tool (OffCAT), which is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs.

    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.
    Tuesday, March 10, 2015 2:20 AM
  • Hi hlpbob007,

    >> My problem is that i have plenty of meetings and sometimes i will have overlap, where I would like put the shapes (normal rectengulars) next to each other or overlapped

    Do you mean that you want to draw shapes in some cells? If so, I would recommend you do as below to achieve your requirement.

    #get the coordinate of the cells, and then get the coordinate of the shapes you want to add, for this, you could use the top, left of the range

    # Range Properties (Excel)
    https://msdn.microsoft.com/EN-US/library/office/dn301006.aspx
    # add a shape with the method Shapes.AddShape, for more information about Shapes.AddShape, you could turn to the link below

    # Shapes.AddShape
    https://msdn.microsoft.com/en-us/library/office/ff821384.aspx

    If I misunderstood you, please feel free to let me know.

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Wednesday, March 11, 2015 9:30 AM